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 departments for a particular location
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
155
From the following table, write a SQL query to find those employees who work in that department where the employee works of ID 201. Return first name, last name, salary, and department ID
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
140
From the following table, write a SQL query to find those employees whose salary matches to the salary of the employee who works in that department of ID 40. Return first name, last name, salary, and department ID
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
139
From the following table, write a SQL query to find those employees who work in the department 'Marketing'. Return first name, last name and department ID
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
194
From the following table, write a SQL query to find those employees who earn more than the minimum salary of a department of ID 40. Return first name, last name, salary, and department ID
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
138
From the following table, write a SQL query to find those employees who joined after the employee whose ID is 165. Return first name, last name and hire date
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 who earn less than the minimum salary of a department of ID 70. Return first name, last name, salary, and department ID
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
141
rom the following table, write a SQL query to find those employees who earn less than the average salary,
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
121
From the following tables, write a SQL query to find those employees whose department is located in the city 'London'. Return first name, last name, salary, and department ID
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
103
From the following tables, write a SQL query to find the city of the employee of ID 134. Return city
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
174
From the following tables, write a SQL query to find those departments where maximum salary is 7000 and above
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
161
From the following tables, write a SQL query to find those departments where starting salary is at least 8000
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
162
From the following table, write a SQL query to find those managers who supervise four or more employees
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
133
Total:
5601
Previous
226
227
228
229
230
Next
Go