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 those employees who do not earn any commission.Return full name
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
161
From the following table, write a SQL query to find those employees whose salary is in the range 9000,17000
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
123
From the following table, write a SQL query to find those employees whose salary is higher than 8000
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
185
From the following table, write a SQL query to count number of orders by the combination of each order date and salesperson. Return order date
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
136
From the following table, write a SQL query to calculate the average product price. Return average product price
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
175
From the following table, write a SQL query to count number of products where product price is higher than or equal to 350. Return number of products
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
201
From the following table, write a SQL query to compute the average price for unique companies. Return average price and company id
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
185
From the following table, write a SQL query to find the number of employees in each department. Return department code and number of employees
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
98
From the following table, write a SQL query to select all the salespeople. Return salesman_id, name, city, commission with the percent sign (%)
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
138
From the following table, write a SQL query to find the number of orders booked for each day. Return the result in a format like "For 2001-10-10 there are 15 orders"
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
149
From the following table, write a SQL query to find all the orders. Sort the result-set in ascending order by ord_no. Return all fields
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
188
From the following table, write a SQL query to find all the orders. Sort the result-set in descending order by ord_date. Return all fields
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
259
From the following table, write a SQL query to find all the orders. Sort the result-set in descending order by ord_date and purch_amt. Return all fields
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
124
Total:
5601
Previous
239
240
241
242
243
Next
Go