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
144
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
114
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
167
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
131
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
157
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
180
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
168
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
95
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
124
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
139
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
175
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
232
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
114
Total:
5601
Previous
239
240
241
242
243
Next
Go
