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 find all the customers. Sort the result-set by customer_id. Return cust_name, city, grade
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 maximum purchase amount generated by each sales person for every order date
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
157
From the following table, write a SQL query to find all the customers. Sort the result-set in descending order on 3rd field. Return customer name, city and grade
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
180
From the following table, write a SQL query to count number of salespeople who belongs to a city. Return number of salespeople
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
90
From the following table, write a SQL query to count all the orders generated on '2012-08-17'. Return number of orders
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
144
From the following table, write a SQL query to find those rows where col1 contains the character percent ( % ). Return col1
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
134
From the following table, write a SQL query to find those rows where col1 does not contain the character percent ( % ). Return col1
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
154
From the following table, write a SQL query to find all those customers who does not have any grade. Return customer_id, cust_name, city
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
147
From the following table, write a SQL query to find all those customers whose grade value exists. Return customer_id, cust_name, city, grade,
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
133
From the following table, write a SQL query to find the employees whose last name begins with the character 'D'. Return emp_idno, emp_fname,
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
205
From the following table, write a SQL query to calculate total purchase amount of all orders. Return total purchase amount
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
152
From the following table, write a SQL query to calculate total purchase amount of all orders. Return total purchase amount
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
173
From the following table, write a SQL query to calculate total purchase amount of all orders. Return total purchase amount
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
146
Total:
5601
Previous
240
241
242
243
244
Next
Go
