Recent questions tagged sql

1 votes
1 answer
31
Consider the following schema:$$\begin{array} {l} \text{Sailors}(\; \underline{\textit{sid: } \textsf{integer}}, \textit{ sname: } \textsf{string}, \textit{ rating: } \te...
1 votes
0 answers
34
0 votes
1 answer
35
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
0 votes
2 answers
37
0 votes
2 answers
38
how both query result is the same, please give an example.