Player plyld plyName Hilal Sport spld 1 Record spName Football #plyld #evCode place 1 1 El 2 Tarek Tennis 1 E6 4 Swimming 2 Cycling 3 Sultan 3 4 Salim 4 E2 1 E5 1 Event 3 ЕЗ 32 3 E8 8 evCode #spId evPlayes 4 ev Title E4 3 Mini Foot Fest Ibri Tour El 1 75 4 E7 1 E2 4 15 Oman Open Arab Sea Race Muscat Cycling Dhofar Fest E3 32 E4 3 36 E5 4 48 E6 1 115 E7 Indoors Cup Suhar Open 3 32 B8 64 Note: primary keys are underlined, foreign keys have #. Answer the following questions : (after executing the SQL command, copy the command and screen s result in a word file. Do not forget to indicate the question number, save the file with your student n and send it by email) Q3. Write SQL queries to do the following: A. List names of all players. B. List event titles of events of sport 2. C. Display the number of plaxest of event E6. D. List names of players who obtained first place in any event. E. List average number of Swimming events participants.

Player plyld plyName Hilal Sport spld 1 Record spName Football #plyld #evCode place 1 1 El 2 Tarek Tennis 1 E6 4 Swimming 2 Cycling 3 Sultan 3 4 Salim 4 E2 1 E5 1 Event 3 ЕЗ 32 3 E8 8 evCode #spId evPlayes 4 ev Title E4 3 Mini Foot Fest Ibri Tour El 1 75 4 E7 1 E2 4 15 Oman Open Arab Sea Race Muscat Cycling Dhofar Fest E3 32 E4 3 36 E5 4 48 E6 1 115 E7 Indoors Cup Suhar Open 3 32 B8 64 Note: primary keys are underlined, foreign keys have #. Answer the following questions : (after executing the SQL command, copy the command and screen s result in a word file. Do not forget to indicate the question number, save the file with your student n and send it by email) Q3. Write SQL queries to do the following: A. List names of all players. B. List event titles of events of sport 2. C. Display the number of plaxest of event E6. D. List names of players who obtained first place in any event. E. List average number of Swimming events participants.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

How google changed our lives?
Google brought us what?
The science of computing The Internet has altered many facets of modern life. There are many positives to using the Internet, but it also comes with a few drawbacks. In your opinion, what are the Internet's primary benefits and drawbacks?
What has Google done for us?
How has Google changed our lives?
Can you explain how the proliferation of the web has impacted the computer manufacturing industry?
What are your opinions on the most recent changes Google made to its search algorithms?
please attempt it on the info provided, subject is HCI(human computer interaction) our project LocateKarLo is an app for THE PEOPLE, we have combined the ideas of cab booking apps and our general public, that includes finding live location of the public transfort, and also if you want to, you can reserve seats for your trips, you can check information about your rides and see if there are available seats in the coming bus also how many people will be getting out, you can also book rides to come pick you up from your doorstep, its definitely an app, one of its kind.
Do you think there will come a day when apps will totally replace the web? Could you perhaps provide your own explanations for why you believe that this particular course of action is appropriate?
Why is the WWW believed to be its own thing, independent of the rest of the Internet?
What hurdles did Google encounter during its first entry into China?
Amazon : Wrestling Big Ideas 944 Words