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 tables write a SQL query to find the salespeople who deal the customers with more than one order
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
150
From the following tables write a SQL query to find the salespeople who deals those customers who live in the same city. Return salesman_id, name, city and commission
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
159
From the following tables, write a SQL query to find the customers whose orders issued on 17th August, 2012
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
169
From the following tables, write a SQL query to find all those salespeople whose name exist alphabetically after the customer’s name. Return salesman_id, name, city,
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
277
From the following table, write a SQL query to find all those customers who have a greater grade than any customer who belongs to the alphabetically lower than the city
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
148
From the following tables, write a SQL query to find those orders where an order amount less than any order amount of a customer lives in London City
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
167
From the following tables, write a SQL query to find those orders where every order amount less than the maximum order amount of a customer lives in London City
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
120
From the following tables, write a SQL query to find those customers whose grade are higher than customers living in New York City
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
160
From the following tables, write a SQL query to calculate the total order amount generated by a salesman
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
105
From the following tables, write a SQL query to find those customers whose grade doesn't same of those customers live in London City
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
145
From the following tables, write a SQL query to find those customers whose grade are not same of those customers living in Paris. Return customer_id, cust_name, city,
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
232
From the following tables, write a SQL query to find those salespeople who earned the maximum commission. Return ord_no, purch_amt, ord_date, and salesman_id
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
226
From the following tables, write a SQL query to count number of customers with grades above the average grades of New York City
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
159
Total:
5601
Previous
230
231
232
233
234
Next
Go
