TOPIC 9.4 | DATABASES
|
|
ON THIS PAGE
Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table. Limited to: – SELECT – FROM – WHERE – ORDER BY – SUM – COUNT • Identifying the output given by an SQL statement that will query the given contents of a database table |
|
|
|
|
EmployeeID |
Name |
Department |
Salary |
JoinDate |
1 |
JohnDoe |
Engineering |
70000 |
2020-01-10 |
2 |
Jane Doe |
Marketing |
50000 |
2019-06-23 |
3 |
Jim Beam |
Engineering |
80000 |
2021-03-15 |
4 |
Jack Ray |
Sales |
45000 |
2022-07-01 |
5 |
Jill May |
Marketing |
55000 |
2021-11-09 |
|
|
SUGGESTIONS
We would love to hear from you |
SUBSCRIBE
To enjoy more benefits |