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
150
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
117
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
173
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
132
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
164
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
188
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
172
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
96
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
127
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
143
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
179
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
240
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
118
Total:
5601
Previous
239
240
241
242
243
Next
Go
