In MySQL 1. select all the columns from the employees table where the city is al
ID: 3747563 • Letter: I
Question
In MySQL
1. select all the columns from the employees table where the city is allen and the state is SD.
2. select all the columns from the employees table where city is allen and state is NY.
3. select all the columns from employees where city is allen and the employee's last name is smith
4. select all the columns from employees where city is south and the employee's first name is = 'dorra';
5. select * from employees where city is lane and employee last name is hall;
6. select all from employees where city is cake and employee last name is rain
7. select all from students where city is here and state is ky
8. select all from students where city is there and state is ky
9. select all from students where city is somewhere and state is ky
10. select all from students where the first name is jill and the city is somewhere
11. select all from vendors where the vendor code is 02 and the credit is 2500.00
12. select all from employees where the state can be either SD or NY
13. select all from employees where the state can be wither KY or NY
14. select all from employees where the city is town or foto
15. select all from products where the product name is sofa or the price is more than 50.00
16. select all from products where the product name is stove or price is equal 59.99
17. select all from products where product name is sink and the price is 87.99 or 59.99
18. select all from students where the last name is smith and the first name is either fred or ben
19. select all from employees where the last name is clack and the state is either KY or OH
20. select all from vendors where credit is equal to 1500.00 or more then 1000.00;
21. select all from vendors where credit is 1500.00 or 1800.00
22. select all from vendors where credit is 1500.00 or credit is less than 100.00
23. select all from vendors where the credit is more than 1500.00 or less than 1000.00
Explanation / Answer
1. select all the columns from the employees table where the city is allen and the state is SD.
mysql>select * from employees where city='allen' and state='SD';
2. select all the columns from the employees table where city is allen and state is NY.
mysql>select * from employees where city='allen' and state='NY';
3. select all the columns from employees where city is allen and the employee's last name is smith
mysql>select * from employees where city='allen' and lastname='smith';
4. select all the columns from employees where city is south and the employee's first name is = 'dorra';
mysql>select * from employees where city='south' and firstname='dorra';
5. select * from employees where city is lane and employee last name is hall;
mysql>select * from emplyees where city='lane' and lastname='hall';
6. select all from employees where city is cake and employee last name is rain
mysql>select * from employees where city='cake' and lastname='rain';
7. select all from students where city is here and state is ky
mysql>select * from students where city='here' and state='ky';
8. select all from students where city is there and state is ky
mysql>select * from students where city='there' and state='ky';
9. select all from students where city is somewhere and state is ky
mysql>select * from students where city='somewhere' and state='ky';
10. select all from students where the first name is jill and the city is somewhere
mysql>select * from students where firstname='jill' and city='somewhere';
11. select all from vendors where the vendor code is 02 and the credit is 2500.00
mysql>select * from vendors where vendorcode=02 and credit=2500.00;
12. select all from employees where the state can be either SD or NY
mysql>select * from employees where state='SD' or state='NY';
13. select all from employees where the state can be wither KY or NY
mysql>select * from employees where state='KY' or state='NY';
14. select all from employees where the city is town or foto
mysql>select * from employees where city='town' or city='foto';
15. select all from products where the product name is sofa or the price is more than 50.00
mysql>select * from products where productname='sofa' or price>50.00;
16. select all from products where the product name is stove or price is equal 59.99
mysql>select * from products where productname='stove' or price=59.99;
17. select all from products where product name is sink and the price is 87.99 or 59.99
mysql>select * from products where productname='sink' and (price=87.99 or price=59.99);
18. select all from students where the last name is smith and the first name is either fred or ben
mysql>select * from students where lastname='smith' and (firstname='fred' or firstname='ben');
19. select all from employees where the last name is clack and the state is either KY or OH
mysql>select * from employees where lastname='clack' and (state='KY' or state='OH');
20. select all from vendors where credit is equal to 1500.00 or more then 1000.00;
mysql>select * from vendors where credit=1500.00 or credit>1000.00;
21. select all from vendors where credit is 1500.00 or 1800.00
mysql>select * from vendors where credit=1500.00 or credit=1800.00;
22. select all from vendors where credit is 1500.00 or credit is less than 100.00
mysql>select * from vendors where credit=1500.00 or credit<100.00;
23. select all from vendors where the credit is more than 1500.00 or less than 1000.00
mysql>select * from vendors where credit>1500.00 or credit<1000.00;
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.