Attempt to do the following queries in the VM, create a report that summaries th
ID: 3744177 • Letter: A
Question
Attempt to do the following queries in the VM, create a report that summaries the queries you used and discuss any observations, problems, successes you encountered. NOTE: These queries require you to think about what is being asked and then translate them to a query that makes sense. You may have to study the table to determine how to create the query.
1. No question 1
2. Display all the fields and records in the categories table
3. How many suppliers are from the US?
4. Display only those employees that are in London?
5. Who is the oldest employee?
6. Change category name from Confections to Desserts
7. Insert a new category called Specialty
Explanation / Answer
2)select * from categories
3)select count(supplierid) as count from categories
where country='US';
4)select * from employees
where city='london';
5)select name from employees
where age=(select max(age) from employees);
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.