Question: Give SQL command for the following questions: WORLD CUP Year Host Country Winner Runner Up MVP 1930 Uruguay Uruguay Argentina Jos Nasazzi 1934 Italy Italy

Give SQL command for the following questions:

WORLD CUP

Year

Host Country

Winner

Runner Up

MVP

1930

Uruguay

Uruguay

Argentina

Jos Nasazzi

1934

Italy

Italy

Czechoslovakia

Giuseppe Meazza

1938

France

Italy

Hungary

Lenidas da Silva

1950

Brazil

Uruguay

Brazil

Zizinho

1954

Switzerland

West Germany

Hungary

Ferenc Pusks

1958

Sweeden

Brazil

Sweeden

Didi

1962

Chile

Brazil

Czechoslovakia

Garrincha

1966

England

England

West Germany

Bobby Charlton

1970

Mexico

Brazil

Italy

Pel

1974

West Germany

West Germany

Holland

Johan Cruyff

1978

Argentina

Argentina

Holland

Mario Kempes

1982

Spain

Italy

Germany

Paolo Rossi

1986

Mexico

Argentina

Germany

Maradona

1990

Italy

West Germany

Argentina

Salvatore Schillaci

1994

USA

Brazil

Italy

Romrio

1998

France

France

Brazil

Ronaldo

2002

South Korea

Brazil

Germany

Ronaldo

2006

Germany

Italy

France

Zidane

2010

South Africa

Spain

Holland

Diego Forln

2014

Brazil

Null

Null

Null

NATION

Country

Continent

Brazil

South America

Argentina

South America

Uruguay

South America

Italy

Europe

Germany

Europe

France

Europe

England

Europe

Spain

Europe

For the tables above, write an SQL statement that

34) Lists the name of the country that won the most ?

35) List the year and name of the host country that won when it hosted

36) List the information of all world cups in ascending order by MVP name

37) Lists the name of the continent and how many times that continent won (two tables).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Help me this quesiton in C++ and please Don't use class . Thank you world_cup_champion.txt Year Country Coach Captain 1930 Uruguay Alberto Suppici Jos Nasazzi 1934 Italy Vittorio Pozzo Gianpiero...

Q:

give sql command for : Write the relational calculus statement to list the names of all employees who have worked on EVERY project in the company.

Q:

Assignment 3 oh Assignments 3 and 4 will give you practice applying what you learned in module 2 to actually create and query a small database using SQL. You will use a very popular open source...

Q:

Supervision V & Employee Department PK Dnumber +---- ---- Works-fer--------------- PK Ssn Dname Fname Minit Lname Sex Bdate Address Salary Dnumber Super SSN FH------- Works on PK,FK2 Pnumber +PK,FK1...

Q:

QUESTION 1 Write the SQL command to list all rows and columns in the Orders table in the TAL Distributors database. You may have the TAL Distributors database open to help you write the command....

Q:

Module 2 Assignment 2 - Basic DDL Statements Overview In this assignment, you will be using SQL command to create tables, populate the tables with some data, then make update and delete records in...

Q:

I would greatly appreciate any help on this, this is an assignment in MySQL. Thank you in advance! 1) Faculty has decided to give all staff members a 5% raise. Create output as shown: Faculty id,...

Q:

1. Consider the following table structures of a certain abc database: student (studentid (PK), studentname, Phone, address) module (modulecode (PK),studentid (FK), modulename startdate, time) write...

Q:

Mandatory assignment 1 Part 1 What to do? Answer the following tasks by typing the SQL statements that give the given result. For each task, type the sql command and end with the semicolon (;) as...

Q:

SOL commands in a hw3.sqt file. Make sure you have set echo on in the beginning of the file. Also, spool : You are your output to hw3.bxt. Run hw3.sql until there is no error. Turn in a print out of...

Q:

Liquid nitromethane was once widely used as an explosive but is now much more common as a fuel for high performance engines in drag racing. How many moles are present in 1.00 gallon of pure...

Q:

Solve using lisp program not python or java. ( lisp emacs ) Write a function called filter-seq that takes a sequences (a string) and an alphabet a (a string), and generates a result sequence (a...

Q:

1. Propane has the chemical formula C3H8. In a good supply of air, it undergoes complete combustion to form carbon dioxide and water. (a) Write a chemical equation for the complete combustion of...

Q:

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Q:

Based on your work or school experience, discuss how roles or status have influenced the way in which people communicated. (Objective 3)

Q:

Why do organizations value both internal and external communication?

Q:

Compose a variety of follow-up letters and other employment related messages.