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
139
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
154
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
176
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
87
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
139
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
133
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
150
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
140
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
130
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
197
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
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
168
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
140
Total:
5601
Previous
240
241
242
243
244
Next
Go
