SQL TREASURE HUNT
Authored by ARUNADEVI FXADT007
Engineering
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SELECT Location, SUM(Quantity) FROM Inventory GROUP BY Location HAVING COUNT(DISTINCT ItemName) > 1;
Which location has more than one distinct item and what is the sum of the quantities there?
Warehouse A, 15
Warehouse B, 35
Warehouse A, 25
Warehouse B, 25
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The minimum number of tables needed to represent M, N, P, R1, and R2 is
2
3
4
5
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL query will find orders placed in the last 30 days that have no matching customer?
SELECT order_id FROM Orders
WHERE order_date >= CURDATE() - INTERVAL 30 DAY
AND customer_id IS NULL;
SELECT o.order_id FROM Orders o
LEFT JOIN Customers c ON o.customer_id = c.customer_id
WHERE c.customer_id IS NULL AND o.order_date >= CURDATE() - INTERVAL 30 DAY;
SELECT order_id FROM Orders
WHERE order_date >= DATE_SUB(NOW(), INTERVAL 30 DAY);
SELECT o.order_id FROM Orders o
JOIN Customers c ON o.customer_id = c.customer_id
WHERE o.order_date >= CURDATE() - INTERVAL 30 DAY;
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SELECT ProductID FROM Sales GROUP BY ProductID HAVING COUNT(DISTINCT SaleDate) > 2;
Which product ID was sold on more than two distinct dates?
101
102
103
None
5.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
What is the minimum number of table needed ?
one
two
four
three
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL query will return transactions with a NULL amount?
SELECT * FROM Transactions WHERE amount = 0;
SELECT * FROM Transactions WHERE amount = NULL;
SELECT * FROM Transactions WHERE amount IS NULL;
SELECT * FROM Transactions WHERE amount NOT NULL;
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which query correctly retrieves these products?
SELECT p.product_id, p.name FROM Products p
JOIN Discounts d ON p.product_id = d.product_id
WHERE d.discount_percentage > 50 AND p.category = 'Luxury';
SELECT p.product_id, p.name FROM Products p
WHERE discount_percentage > 50 AND category = 'Luxury';
SELECT p.product_id, p.name FROM Discounts d
WHERE discount_percentage > 50 AND category = 'Luxury';
SELECT product_id, name FROM Products
WHERE discount_percentage > 50 OR category = 'Luxury';
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
%20(1).png)
Apple
Others
Already have an account?
