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 those customers whose grade less than 300. Return cust_name, customer city, grade, Salesman, saleman city
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
194
From the following tables write a SQL query to display the cust_name, customer city, grade, Salesman, salesman city. The result should be ordered
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
136
Write a SQL statement to make a join on the tables salesman, customer and orders in such a form that the same column of each table
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
227
From the following tables write a SQL query to find the details of an order. Return ord_no, ord_date, purch_amt
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
179
From the following table, write a SQL query to calculate average salary of those employees for each department who get a commission percentage
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
138
From the following table, write a SQL query to find all those employees who are either Sales Representative or Salesman
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
103
From the following table, write a SQL query to find those departments where a manager can manage four or more employees
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
168
From the following table, write a SQL query to find those departments where more than ten employees work,
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
153
From the following table, write a SQL query to find those employees who have completed their previous jobs
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
151
From the following table, write a SQL query to find those employees who have no commission percentage and salary within the range 7000,
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
132
From the following table, write a SQL query to compute the average salary of each job ID
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
156
From the following table, write a SQL query to find those job titles where the difference between minimum and maximum salaries is in the range the range 12000, 18000
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
154
From the following table, write a SQL query to find those employees whose first name or last name starts with the letter ‘D’
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
291
Total:
5601
Previous
235
236
237
238
239
Next
Go
