Question
Use the university_cars_video_kronke database for the following. 1. Write a query to display the try_id, cus_id, make, model, and year of all cars, including those
Use the university_cars_video_kronke database for the following.
1. Write a query to display the try_id, cus_id, make, model, and year of all cars, including those that have not been tried.
2. Write a query to display the eid, first name, and last name of all employees in the cars database who were involved in more than one purchase.
3, Write a query to display all employee details (eid, fname, lname) that have sold a car along with each vin number of cars that they have sold. Your results should also include details of all employees that have not yet sold a car.
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