-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsample.txt
More file actions
48 lines (25 loc) · 968 Bytes
/
Copy pathsample.txt
File metadata and controls
48 lines (25 loc) · 968 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
✅ Test Queries (Simple & Focused)
🔹 For students table:
"List all students."
"Show names and grades of all students."
"How many students are in class 10?"
"List all female students in section B."
"Show students who scored more than 90 in maths."
"Give names and addresses of students with grade 'A'."
"List students aged between 14 and 16."
🔹 For products table:
"List all products in the electronics category."
"Show all out-of-stock products."
"What is the price of 'iPhone 14'?"
"List all products that cost more than 500."
"How many products are available in stock?"
🔹 For users table:
"List all users."
"Show usernames and signup dates of users who joined in 2023."
"How many users have status 'active'?"
🔹 For pizza_reviews table:
"List all pizza reviews."
"Show titles and ratings of reviews with rating above 4."
"How many reviews are there in total?"
"List reviews written after January 1, 2024."
"Show the latest review."