Question
SQL QUESTION 1. select all the columns from the employees table where the city is allen and the state is SD. +---------+----------+-----------+----------------+-------+-------+-------+ | EMP_NUM |
SQL QUESTION
1. select all the columns from the employees table where the city is allen and the state is SD. +---------+----------+-----------+----------------+-------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+----------------+-------+-------+-------+ | 2 | Smith | Paula | 23 South Lane | Allen | SD | 08262 | | 8 | Chenny | Terry | 12 West Road | Allen | SD | 08932 | | 17 | Holmes | Cora | 17 West Street | Allen | SD | 19836 | +---------+----------+-----------+----------------+-------+-------+-------+ 3 rows in set (0.00 sec)
2. select all the columns from the employees table where city is allen and state is NY. +---------+----------+-----------+----------+-------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+----------+-------+-------+-------+ | 1 | MorriS | Tony | 123 Main | Allen | NY | 23412 | +---------+----------+-----------+----------+-------+-------+-------+ 1 row in set (0.00 sec)
3. select all the columns from employees where city is allen and the employee's last name is smith +---------+----------+-----------+---------------+-------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+---------------+-------+-------+-------+ | 2 | Smith | Paula | 23 South Lane | Allen | SD | 08262 | +---------+----------+-----------+---------------+-------+-------+-------+ 1 row in set (0.00 sec)
4. select all the columns from employees where city is south and the employee's first name is = 'dorra'; +---------+----------+-----------+----------------+-------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+----------------+-------+-------+-------+ | 13 | Smith | Dorra | 102 North Road | South | KY | 42142 | +---------+----------+-----------+----------------+-------+-------+-------+ 1 row in set (0.01 sec)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started