SQL statements
Not what you're looking for?
I am seeking help with solving several SQL statements.
Table: Employee (for problems #1 and #2)
EmpID Dept Salary HireDate SupervisorID
1001 Finance 10,000 11/1/98 1020
1002 Finance 15,000 12/12/96 1020
1020 Finance 30,000 2/9/96 1035
1015 Human Resources 20,000 3/15/01 1045
1008 Operations 9,000 8/22/97 1013
1010 Operations 12,000 7/9/01 1013
1035 Operations 40,000 9/14/95 1000
1007 Maintenance 5,000 10/7/01 1017
1050 Human Resources 10,000 4/5/98 1045
1000 Executive 60,000 11/25/93
1016 Human Resources 11,000 10/13/01 1045
1) Using table Employee, Delete all employees from the Finance department who make less than $20,000 and were hired during the year 2001.
Please see attached
Purchase this Solution
Solution Summary
SQL statements are assessed.
Solution Preview
DELETE FROM EMPLOYEE
WHERE Dept = 'Finance'
AND Salary < '20,000'
AND HireDate BETWEEN '01/01/01' AND '12/31/01';
Here we're assuming that "Salary" is stored as a string with ...
Purchase this Solution
Free BrainMass Quizzes
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
C# variables and classes
This quiz contains questions about C# classes and variables.