Provide SQL queries and the result tables for the following Please ensure that y

Question

Provide SQL queries and the result tables for the following Please ensure that you include the result table as well as your SQL; you can copy and paste this from either your ssh client or SQL Developer. These tables exist in sphinx and are owned by the user dtoohey. The database being used for this question is structured as follows with Primary Keys bolded and Foreign Keys underlined. Countries (Name, Country_ID, area sqkm, population) Teams (team_id, name, country_id. description, manager) Stages (stage_id. Took_olace, start_loc, end_loc. distance, description) Riders (rider_id, name, team_id, year_born, height_cms, weight_kgs, country_id, bmi) Results (stage_id. Rider_id, time_seconds) This database includes the results of the 2012 Tour de France. Riders are from countries and ride stages for teams. Teams are from countries. Write a query to find the teams that contain at least 6 riders from the same country as the country that the team is from. Bradley Wiggins won the tour. Write a query to find the riders who beat him in at least 4 stages, i.e., riders who had a better time than Wiggins in at least 4 of the 21 stages.

Explanation / Answer

2.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.