MySQL Forums
Forum List  »  Newbie

Questions for mySQL assignment problems.
Posted by: Zain Ahmed
Date: March 31, 2021 02:51AM

Hi, I'm new here and I have only 1 day left to deliver my assignment.

I have 5 following questions: And how do I write the code for it?


-- Q6: Ask a query, which shows, which model (in this case "Opel Kadett") is mentioned more than once in the attribute model in bil-table.

-- Q7: one of the mechanics is a veteran. can you find out who is it?: HINT: He worked with most cars that are more than 25 years old.

-- Q8: List all cars, based on their mean price for each reparation.

-- Q9: The Employer in the workshop will like to give a bonus to this mechanic, who earned the most money. Which one should have the bonus?

-- Q10 Poul Wanted a list of other mechanics, who worked in the one quarter of a year, but he is interested only in the first and the last quarter of the year.

Options: ReplyQuote


Subject
Written By
Posted
Questions for mySQL assignment problems.
March 31, 2021 02:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.