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
148
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
126
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
192
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
139
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
163
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
129
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
125
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
149
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
159
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
139
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
300
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
321
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
317
Total:
5601
Previous
243
244
245
246
247
Next
Go
