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
170
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
177
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
187
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
283
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
156
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
184
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
128
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
177
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
114
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
161
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
247
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
236
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
176
Total:
5601
Previous
230
231
232
233
234
Next
Go
