Given two tables 'orders' and 'customers' with a common column 'customer_id', write a query to retrieve the customer details (name, email) for all the customers who have placed at least one order.

SELECT customers.name, customers.email FROM customers JOIN orders ON customers.customer_id = orders.customer_id

SELECT customers.name, customers.email FROM customers INNER JOIN orders ON customers.customer_id = orders.customer_id

SELECT customers.name, customers.email FROM customers RIGHT JOIN orders ON customers.customer_id = orders.customer_id

SELECT customers.name, customers.email FROM customers LEFT JOIN orders ON customers.customer_id = orders.customer_id

Given a table named 'orders' with columns 'id', 'order_date', and 'customer_id', write a query to retrieve the most recent order for each customer.

SELECT customer_id, MAX(order_date) AS latest_order FROM orders GROUP BY customer_id

SELECT customer_id, order_date FROM orders ORDER BY order_date DESC LIMIT 1

SELECT customer_id, order_date FROM orders WHERE order_date = (SELECT MAX(order_date) FROM orders)

SELECT customer_id, order_date FROM orders GROUP BY customer_id ORDER BY order_date DESC

Consider a table named 'employees' with columns 'id', 'name', 'salary'. Write a query to increase the salary by 10% for all employees earning less than 50000.

UPDATE employees SET salary = salary * 1.10 WHERE salary

UPDATE employees SET salary = salary + (salary * 0.10) WHERE salary > 50000

SELECT * FROM employees WHERE salary

UPDATE employees SET salary = salary / 1.10 WHERE salary

Given a table named 'employees' with columns 'id', 'name', 'hire_date', write a query to retrieve all employees who were hired in the last 30 days.

SELECT * FROM employees WHERE hire_date >= CURDATE() - INTERVAL 30 DAY

SELECT * FROM employees WHERE hire_date >= NOW() - INTERVAL '30 days'

SELECT * FROM employees WHERE hire_date

SELECT * FROM employees WHERE hire_date BETWEEN CURDATE() - INTERVAL 30 DAY AND CURDATE()

SQL Queries Quiz

Quiz

•

Computers

•

University

•

Practice Problem

•

Hard

Shubhi U

Used 3+ times

FREE Resource

13 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Consider a table named 'students' with columns 'id', 'name', and 'age'. Write a query to retrieve all the students whose age is greater than 18.

SELECT * FROM students WHERE age < 18;

SELECT * FROM students WHERE age >= 18;

SELECT * FROM students WHERE age > 18;

SELECT * FROM students WHERE age = 18;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Given two tables 'orders' and 'customers' with a common column 'customer_id', write a query to retrieve all the orders along with the customer details (name, email) for each order.

SELECT orders.*, customers.name, customers.email FROM orders JOIN customers ON orders.customer_id = customers.customer_id

SELECT orders.*, customers.name, customers.email FROM orders LEFT JOIN customers ON orders.customer_id = customers.customer_id

SELECT orders.*, customers.name, customers.email FROM orders RIGHT JOIN customers ON orders.customer_id = customers.customer_id

SELECT * FROM orders, customers WHERE orders.customer_id = customers.customer_id

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Consider a table named 'employees' with columns 'id', 'name', 'department_id', and a table named 'departments' with columns 'id' and 'name'. Write a query to retrieve the names of all employees along with their corresponding department names.

SELECT employees.name, departments.name FROM employees LEFT JOIN departments ON employees.department_id = departments.id

SELECT employees.name, departments.name FROM employees JOIN departments ON employees.department_id = departments.id

SELECT employees.name, departments.name FROM employees WHERE employees.department_id = departments.id

SELECT employees.name, departments.name FROM employees INNER JOIN departments ON employees.department_id = departments.id WHERE employees.department_id IS NOT NULL

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Given a table named 'products' with columns 'id', 'name', and 'price', write a query to retrieve the product with the highest price.

SELECT * FROM products WHERE price = (SELECT AVG(price) FROM products)

SELECT * FROM products WHERE price = (SELECT MIN(price) FROM products)

SELECT * FROM products WHERE price = (SELECT SUM(price) FROM products)

SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Consider a table named 'students' with columns 'id', 'name', and 'age'. Write a query to retrieve the names of all students whose name starts with the letter 'A'.

SELECT name FROM students WHERE name LIKE '_A%'

SELECT name FROM students WHERE name LIKE 'A%'

SELECT name FROM students WHERE name LIKE 'A_'

SELECT name FROM students WHERE name LIKE '%A'

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Given two tables 'orders' and 'customers' with a common column 'customer_id', write a query to retrieve the total number of orders for each customer.

SELECT customers.customer_id, COUNT(orders.order_id) AS total_orders FROM customers JOIN orders ON customers.customer_id = orders.customer_id GROUP BY customers.customer_id

SELECT customers.customer_id, COUNT(orders.order_id) AS total_orders FROM customers RIGHT JOIN orders ON customers.customer_id = orders.customer_id GROUP BY customers.customer_id

SELECT customers.customer_id, COUNT(orders.order_id) AS total_orders FROM customers LEFT JOIN orders ON customers.customer_id = orders.customer_id GROUP BY customers.customer_id

SELECT customers.customer_id, COUNT(orders.order_id) AS total_orders FROM customers INNER JOIN orders ON customers.customer_id = orders.customer_id GROUP BY customers.customer_id

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Consider a table named 'employees' with columns 'id', 'name', 'department_id', and a table named 'departments' with columns 'id' and 'name'. Write a query to retrieve the names of all departments along with the count of employees in each department.

SELECT departments.name, COUNT(*) FROM departments JOIN employees ON departments.id = employees.department_id GROUP BY departments.name

SELECT departments.name, COUNT(employees.id) FROM departments JOIN employees ON departments.id = employees.department_id

SELECT departments.name, COUNT(employees.id) FROM departments LEFT JOIN employees ON departments.id = employees.department_id GROUP BY departments.name

SELECT departments.name, COUNT(employees.id) FROM departments JOIN employees ON departments.id = employees.department_id GROUP BY departments.name

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

10 questions

NLP_Unit 1_Quiz

Quiz

•

University

10 questions

RDBMS

Quiz

•

University

15 questions

DBMS LAB QUIZ

Quiz

•

University

15 questions

RLNVSP - Buổi 1 - Ôn tập

Quiz

•

University

16 questions

CIS 1103 Week 7_8 CLO 3 (Part 3)

Quiz

•

University

10 questions

Big Data Analytics

Quiz

•

University

10 questions

Metodologías Ágiles

Quiz

•

University

10 questions

Chapter 5 Test Management Part 1

Quiz

•

University

Popular Resources on Wayground

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

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

30 questions

Quiz 1 Review

Quiz

•

University

SQL Queries Quiz

13 questions

Consider a table named 'students' with columns 'id', 'name', and 'age'. Write a query to retrieve all the students whose age is greater than 18.

Given two tables 'orders' and 'customers' with a common column 'customer_id', write a query to retrieve all the orders along with the customer details (name, email) for each order.

Consider a table named 'employees' with columns 'id', 'name', 'department_id', and a table named 'departments' with columns 'id' and 'name'. Write a query to retrieve the names of all employees along with their corresponding department names.

Given a table named 'products' with columns 'id', 'name', and 'price', write a query to retrieve the product with the highest price.

Consider a table named 'students' with columns 'id', 'name', and 'age'. Write a query to retrieve the names of all students whose name starts with the letter 'A'.

Given two tables 'orders' and 'customers' with a common column 'customer_id', write a query to retrieve the total number of orders for each customer.

Consider a table named 'employees' with columns 'id', 'name', 'department_id', and a table named 'departments' with columns 'id' and 'name'. Write a query to retrieve the names of all departments along with the count of employees in each department.

Given a table named 'products' with columns 'id', 'name', and 'price', write a query to retrieve the average price of all products.

Consider a table named 'students' with columns 'id', 'name', and 'age'. Write a query to retrieve the names of all students whose age is between 20 and 25 (inclusive).

Given two tables 'orders' and 'customers' with a common column 'customer_id', write a query to retrieve the customer details (name, email) for all the customers who have placed at least one order.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers