Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Queries on a remote server Connect to the remote database ErgastF1 and list available tables How many drivers are recorded in the database? Who are

Queries on a remote server

  1. Connect to the remote database ErgastF1 and list available tables
  2. How many drivers are recorded in the database?
  3. Who are the 5 youngest drivers and the 5 oldest ones?
  4. How many races are recorded in the database?
  5. Display the drivers'names and races they ran by decreasing number of podiums they ended up in (results.position equals 1, 2, or 3)
  6. Display the top 10 drivers ranked by their number of pole positions (driverStandings.position equals 1)
  7. How many times did Ayrton Senna won a race? How many times did he finish second?
  8. Display the top 10 constructors ranked by the number of victories of their pilots
  9. Display all constructors and order their victories by driver (decreasing). With which pilot did Ferrari won the highest number of Grand Prix?
  10. With which constructor did Juan Fangio won the highest number of Grand Prix?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle9i Database Administrator Implementation And Administration

Authors: Carol McCullough-Dieter

1st Edition

0619159006, 978-0619159009

More Books

Students also viewed these Databases questions