Which query finds customers from either 'New York' or 'Los Angeles'?

SELECT * FROM customers WHERE city = 'New York' AND city = 'Los Angeles';

SELECT * FROM customers WHERE city IN ('New York', 'Los Angeles');

SELECT * FROM customers WHERE city = 'New York' OR city = 'Los Angeles';

What does the LIKE operator with % do?

Matches any sequence of characters

How do you update the salary of an employee with id = 101 to 75000?

UPDATE employees SET salary = 75000 WHERE id = 101;

MODIFY employees SET salary = 75000 WHERE id = 101;

EDIT employees salary = 75000 WHERE id = 101;

CHANGE employees salary TO 75000 WHERE id = 101;

What happens if you omit the WHERE clause in an UPDATE statement?

All rows in the table are updated

How do you delete a customer with id = 5 from the customers table?

DELETE FROM customers WHERE id = 5;

REMOVE FROM customers WHERE id = 5;

DROP FROM customers WHERE id = 5;

ERASE FROM customers WHERE id = 5;

How do you sort results by name in ascending order?

SELECT * FROM users ORDER BY name ASC;

SELECT * FROM users SORT BY name;

SELECT * FROM users ARRANGE BY name;

SELECT * FROM users GROUP BY name;

What does SELECT DISTINCT department FROM employees; do?

Returns only unique departments

Returns all departments including duplicates

Returns the first department in the table

What is the correct syntax for an INNER JOIN between orders and customers ?

SELECT * FROM orders INNER JOIN customers ON orders.customer_id = customers.id ;

SELECT * FROM orders JOIN customers WHERE orders.customer_id = customers.id ;

SELECT * FROM orders AND customers ON orders.customer_id = customers.id ;

SELECT * FROM orders, customers MATCHING orders.customer_id = customers.id ;

A query that runs after the main query

A query that modifies table structure

Which query finds employees with salaries above the average salary?

SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);

SELECT * FROM employees WHERE salary > AVG(salary);

SELECT * FROM employees HAVING salary > AVG(salary);

SELECT * FROM employees WHERE salary > AVG(salary FROM employees);

Which statement adds a new column phone to the customers table?

ALTER TABLE customers ADD COLUMN phone VARCHAR(15);

MODIFY TABLE customers ADD phone VARCHAR(15);

UPDATE TABLE customers INSERT COLUMN phone VARCHAR(15);

ADD COLUMN phone TO customers VARCHAR(15);

What does the HAVING clause do?

Filters groups after aggregation

Which query retrieves employees whose names start with 'J'?

SELECT * FROM employees WHERE name LIKE 'J%';

SELECT * FROM employees WHERE name = 'J%';

SELECT * FROM employees WHERE name STARTS WITH 'J';

SELECT * FROM employees WHERE name CONTAINS 'J';

What does WHERE salary BETWEEN 30000 AND 60000 return?

Salaries ≥ 30000 and ≤ 60000

Salaries exactly 30000 or 60000

How do you increase all salaries by 10% in the employees table?

UPDATE employees SET salary = salary * 1.1;

UPDATE employees salary += salary * 0.1;

MODIFY employees salary = salary * 10%;

INCREMENT employees salary BY 10%;

Which query deletes orders placed before 2020?

DELETE FROM orders WHERE order_date < '2020-01-01';

DROP orders WHERE order_date < '2020-01-01';

REMOVE FROM orders IF order_date < '2020-01-01';

ERASE orders WHERE order_date BEFORE 2020;

How do you sort by salary (descending) and then by name (ascending)?

SELECT * FROM employees ORDER BY salary DESC, name ASC;

SELECT * FROM employees SORT BY salary DOWN, name UP;

SELECT * FROM employees ORDER BY salary - name;

SELECT * FROM employees GROUP BY salary DESC, name ASC;

What does GROUP BY department HAVING COUNT(*) > 5 do?

Returns departments with more than 5 employees

Returns departments with exactly 5 employees

Returns the first 5 departments

Groups employees into 5 departments

Which query counts the number of unique job titles in employees ?

SELECT COUNT(DISTINCT job_title) FROM employees;

SELECT UNIQUE COUNT(job_title) FROM employees;

SELECT COUNT(job_title) FROM employees GROUP BY job_title;

SELECT DISTINCT COUNT(job_title) FROM employees;

What does SELECT AVG(salary) FROM employees WHERE department = 'Sales'; calculate?

Average salary of Sales employees

Total salary of Sales employees

How do you find customers who have never placed an order?

SELECT * FROM customers LEFT JOIN orders ON customers.id = orders.customer_id WHERE orders.id IS NULL;

SELECT * FROM customers WHERE id NOT IN (SELECT customer_id FROM orders);

SELECT * FROM customers OUTER JOIN orders ON customers.id = orders.customer_id;

Which query finds employees who earn more than the average salary in their department?

SELECT * FROM employees e1 WHERE salary > (SELECT AVG(salary) FROM employees e2 WHERE e1.department = e2.department);

SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);

SELECT * FROM employees GROUP BY department HAVING salary > AVG(salary);

SELECT * FROM employees WHERE salary > DEPARTMENT_AVG(salary);

What does this query return? SELECT name FROM products WHERE price = (SELECT MAX(price) FROM products);

All products with above-average prices

Which query correctly lists departments where the average salary is over $50,000, sorted highest to lowest?

SELECT department, AVG(salary) as avg_salary FROM employees GROUP BY department HAVING AVG(salary) > 50000 ORDER BY avg_salary DESC;

SELECT department, AVG(salary) FROM employees WHERE salary > 50000 GROUP BY department ORDER BY salary DESC;

SELECT department, AVG(salary) FROM employees GROUP BY department WHERE AVG(salary) > 50000 ORDER BY AVG(salary) DESC;

SELECT department, SUM(salary) FROM employees HAVING AVG(salary) > 50000 ORDER BY salary DESC;

What does this query do? UPDATE employees SET salary = salary * 1.05 WHERE department = 'Engineering' AND hire_date < '2020-01-01';

Gives a 5% raise to Engineering employees hired before 2020

Reduces salaries by 5% for Engineering employees

Updates hire dates for Engineering employees

Sets all Engineering salaries to exactly $5,000

How do you find employees with no email address?

SELECT * FROM employees WHERE email IS NULL;

SELECT * FROM employees WHERE email = NULL;

SELECT * FROM employees WHERE email = 'NULL';

SELECT * FROM employees WHERE email = '';

32. Which query lists customers who spent more than $1000 in total?

SELECT c.name FROM customers c JOIN orders o ON c.id = o.customer_id GROUP BY c.id HAVING SUM( o.total ) > 1000;

SELECT c.name FROM customers c WHERE o.total > 1000 JOIN orders o ON c.id = o.customer_id;

SELECT c.name FROM customers c JOIN orders o ON c.id = o.customer_id WHERE SUM( o.total ) > 1000;

SELECT c.name FROM customers c JOIN orders o ON c.id = o.customer_id IF o.total > 1000;

Final Quiz Async 3

Authored by Mark Gangan

Computers

University

Used 5+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

40 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct syntax for inserting a single row into a table named employees?

INSERT INTO employees (id, name, salary) VALUES (1, 'John', 50000);

INSERT employees VALUES (1, 'John', 50000);

ADD TO employees (id, name, salary) (1, 'John', 50000);

INSERT ROW employees (id, name, salary) (1, 'John', 50000);

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which keyword is used to insert multiple rows in a single INSERT statement?

MANY ROWS

BATCH INSERT

MULTIPLE VALUES

Separate VALUES clauses with commas

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement retrieves all columns from a table named customers?

SELECT ALL FROM customers;

SELECT * FROM customers;

GET * FROM customers;

FETCH ALL customers;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you select only the name and email columns from a table users?

SELECT name, email FROM users;

SELECT (name, email) FROM users;

GET name AND email FROM users;

SELECT COLUMNS name, email FROM users;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which clause filters records in a SELECT query?

FILTER BY

HAVING

WHERE

CONDITION

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct syntax to find employees with a salary greater than 50000?

SELECT * FROM employees WHERE salary > 50000;

SELECT * FROM employees IF salary > 50000;

SELECT * FROM employees HAVING salary > 50000;

SELECT * FROM employees CHECK salary > 50000;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you retrieve records where age is greater than 30 and salary is less than 60000?

SELECT * FROM employees WHERE age > 30 OR salary < 60000;

SELECT * FROM employees WHERE age > 30 AND salary < 60000;

SELECT * FROM employees WHERE age > 30, salary < 60000;

SELECT * FROM employees WHERE age > 30 && salary < 60000;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

44 questions

Movies

Quiz

•

2nd Grade - Professio...

40 questions

C&SE PRE-KNOWLEDGE SURVEY (A+ 1102-CORE 2)

Quiz

•

University - Professi...

40 questions

year 3 QUIZ 3 2nd term

Quiz

•

3rd Grade - University

40 questions

Soal Latihan UNBK TKJ

Quiz

•

University

39 questions

Eng-103 Vocab 4

Quiz

•

University

40 questions

CompTIA Security+ SY0-601 Chapters 9 - 12

Quiz

•

University

38 questions

TTL1 QUIZ

Quiz

•

University

40 questions

HTML

Quiz

•

University

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

5 questions

What is Presidents' Day?

Interactive video

•

10th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

20 questions

Mardi Gras History

Quiz

•

6th Grade - University

10 questions

The Roaring 20's Crash Course US History

Interactive video

•

11th Grade - University

17 questions

Review9_TEACHER

Quiz

•

University

Final Quiz Async 3

What is the correct syntax for inserting a single row into a table named employees?

Which keyword is used to insert multiple rows in a single INSERT statement?

Which SQL statement retrieves all columns from a table named customers?

How do you select only the name and email columns from a table users?

Which clause filters records in a SELECT query?

What is the correct syntax to find employees with a salary greater than 50000?

How do you retrieve records where age is greater than 30 and salary is less than 60000?

Which query finds customers from either 'New York' or 'Los Angeles'?

Which operator checks if a value is within a specified range?

What does the LIKE operator with % do?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers