Discover
Questions library
Collections library
Find online teacher
login
Discover
questions library
Find online teacher
login
Popular searches:
if-else
class-diagram
flowchart
Polymorphism
Home
Questions
Questions
Study lists
hamza shaheen Questions
5601 Questions
From the following table, write a SQL query to select a range of products whose price is in the range Rs.200 to Rs.600
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
154
From the following table, write a SQL query to calculate the average price for manufacturer code equal to 16. Return avg
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
128
From the following table, write a SQL query to display the pro_name as 'Item Name' and pro_priceas 'Price in Rs.'
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
199
From the following table, write a SQL query to find the items whose prices are higher than or equal to $250. Order the result by product price in descending
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
145
From the following table, write a SQL query to calculate average price of the items of each company
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
168
From the following table, write a SQL query to find the cheapest item(s). Return pro_name and, pro_price
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
130
From the following table, write a SQL query to find unique last name of all employees. Return emp_lname
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
128
From the following table, write a SQL query to find the details of the employees who work in the department 57
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
153
From the following table, write a SQL query to find the details of employees whose last name is 'Snares'. Return emp_idno, emp_fname, emp_lname, and emp_dept
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
164
From the following table, write a SQL query to find the details of the customers who have a gradevalue above 100. Return
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
140
From the following table, write a SQL query to find all the customers in ‘New York’ city who have a grade value above 100. Return customer_id,
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
304
From the following table, write a SQL query to find the customers who belong to either the city ‘New York’ or have a grade above 100. Return customer_id, cust_name, city, grade, and salesman_id
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
329
From the following table, write a SQL query to find the customers who belong to either the city ‘New York’ or not have a grade above 100. Return customer_id, cust_name, city, grade, and salesman_id
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
324
Total:
5601
Previous
243
244
245
246
247
Next
Go
