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 the employee whose salary is 3000 and reporting person’s ID is 121
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
334
From the following tables, write a SQL query to find those employees who do not work in those departments where manager ids are in the range 100, 200
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
158
From the following tables, write a SQL query to find those employees who work in the same department where 'Clara' works
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
84
From the following tables, write a SQL query to find those employees who work in a department where the employee’s first name contains a letter 'T'
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
283
From the following tables, write a SQL query to find those employees who earn more than the average salary and work in a department with any employee whose first name contains a character a 'J'
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
163
From the following tables write a SQL query to find the salespeople whose place of living (city) matches with any of the city where customers live
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
230
From the following tables, write a SQL query to find the salespeople who had more than one customer
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
155
From the following tables, write a SQL query to find those orders, which are higher than average amount of the orders
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
131
From the following tables, write a SQL query to find those orders, which are equal or higher than average amount of the orders
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
167
Write a query to find the sums of the amounts from the orders table, grouped by date, eliminating all those dates where the sum was not at least 1000.00 above the maximum order amount for that date
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
151
Write a query to extract all data from the customer table if and only if one or more of the customers in the customer table are located in London
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
155
From the following tables, write a SQL query to find the salespeople who deal multiple customers. Return salesman_id, name, city and commission
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
153
From the following tables write a SQL query to find the salespeople who deal a single customer
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
197
Total:
5601
Previous
229
230
231
232
233
Next
Go
