NEW
Font size
WorksheetsChapter 3 : SQL Command
Total questions: 15
Worksheet time: 8mins
Which SQL command correctly creates the ConferenceRoom table?
MAKE TABLE ConferenceRoom (room_id INT, room_name VARCHAR(100), capacity INT);
CREATE ConferenceRoom TABLE (room_id INT, room_name VARCHAR(100), capacity INT);
CREATE TABLE ConferenceRoom (
room_id INT PRIMARY KEY,
room_name VARCHAR(100),
capacity INT
);
TABLE CREATE ConferenceRoom (room_id INT, room_name VARCHAR(100), capacity INT);
Which command inserts a record into Employee?
INSERT Employee (1, 'Alice Tan', 'IT');
INSERT INTO Employee VALUES (1, 'Alice Tan', 'IT');
INSERT INTO Employee (emp_id, emp_name, department) VALUES 'Alice Tan', 1, 'IT';
ADD INTO Employee VALUES (1, 'Alice Tan', 'IT');
Which query changes Workshop with workshop_id = 2 to title "Leadership Skills"?
UPDATE Workshop workshop_title = 'Leadership Skills' workshop_id = 2;
CHANGE Workshop SET workshop_title = 'Leadership Skills' WHERE workshop_id = 2;
UPDATE Workshop SET 'Leadership Skills' WHERE workshop_id = 2;
UPDATE Workshop
SET workshop_title = 'Leadership Skills'
WHERE workshop_id = 2;
Shows all employees from HR department?
SELECT * FROM Employee department = 'HR';
SELECT *
FROM Employee
WHERE department = 'HR';
SELECT emp_name FROM Employee HAVING department = 'HR';
SELECT emp_name FROM Employee GROUP BY department = 'HR';
shows Workshop title and ConferenceRoom name?
SELECT workshop_title, room_name FROM Workshop INNER ConferenceRoom;
SELECT w.workshop_title, c.room_name FROM Workshop w, ConferenceRoom c;
shows employee name, workshop title, and fee paid?
SELECT e.emp_name, w.workshop_title, r.fee
FROM Registration r
JOIN Employee e ON r.emp_id = e.emp_id
JOIN Workshop w ON r.workshop_id = w.workshop_id;
SELECT e.emp_name, w.workshop_title, w.fee FROM Employee, Workshop, Registration;
SELECT e.emp_name, w.workshop_title, r.fee JOIN Employee e, Workshop w;
SELECT emp_name, workshop_title, fee FROM Registration NATURAL JOIN Employee;
finds the highest fee paid?
SELECT fee FROM Registration MAX();
SELECT MAXIMUM(fee) FROM Registration;
SELECT MAX(fee) AS max_fee FROM Registration;
SELECT MAX fee FROM Registration;
finds the smallest fee paid?
SELECT fee MIN FROM Registration;
SELECT MIN(fee) FROM Registration;
SELECT MINIMUM fee FROM Registration;
SELECT fee FROM Registration WHERE MIN;
calculates the total fee collected?
SELECT ADD(fee) FROM Registration;
SELECT SUM(fee) FROM Registration;
SELECT fee SUM FROM Registration;
SUM(fee) SELECT FROM Registration;
counts total registrations?
SELECT COUNT(*) FROM Registration;
SELECT COUNT(ALL) Registration;
SELECT COUNT Registration;
COUNT(*) FROM Registration;
finds employees whose name starts with 'A'?
SELECT emp_name FROM Employee WHERE emp_name = 'A*';
SELECT * FROM Employee
WHERE emp_name LIKE 'A%';
SELECT * FROM Employee WHERE emp_name LIKE A%;
SELECT * FROM Employee HAVING emp_name LIKE 'A%';
lists workshops in date order (earliest first)?
SELECT workshop_title, workshop_date FROM Workshop SORT BY workshop_date;
SELECT workshop_title, workshop_date
FROM Workshop
ORDER BY workshop_date ASC;
SELECT workshop_title, workshop_date FROM Workshop ORDER workshop_date;
SELECT workshop_title, workshop_date FROM Workshop BY workshop_date;
Find the groups registrations by workshop and counts as total registration?
SELECT workshop_id, COUNT(*) AS total_regs
FROM Registration
GROUP BY workshop_id;
SELECT workshop_id, COUNT(*) FROM Registration;
SELECT workshop_id, COUNT(*) GROUP Registration;
SELECT workshop_id, COUNT() FROM Registration GROUP BY workshop_id;
finds fees between 100 and 200?
SELECT * FROM Registration
WHERE fee BETWEEN 100 AND 200;
SELECT * FROM Registration WHERE fee >= 100 <= 200;
SELECT * FROM Registration WHERE fee IN 100 TO 200;
SELECT * FROM Registration HAVING fee BETWEEN 100 AND 200;
shows employees from the IT department AND whose emp_id is greater than 1?
SELECT *
FROM Employee
WHERE department = 'IT' AND emp_id > 1;
SELECT emp_name FROM Employee WHERE department = 'IT' OR emp_id > 1;
SELECT emp_name FROM Employee WHERE department = 'IT' AND emp_id => 1;
SELECT emp_name FROM Employee HAVING department = 'IT' AND emp_id > 1;
