Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DAO Soru: 3/3 Ops al al 1001 03134009050040903 GAME 315400905151405400g BESIDE 05 GID GameName PlayerNums TrophyPrice Date 0325200315400903 4330091031340091 03:30 09:03 1001 Football 11 10000

image text in transcribed

DAO Soru: 3/3 Ops al al 1001 03134009050040903 GAME 315400905151405400g BESIDE 05 GID GameName PlayerNums TrophyPrice Date 0325200315400903 4330091031340091 03:30 09:03 1001 Football 11 10000 11/12/2020 1002 Basketball 5 12000 23/06/2020 1003 Volleyball 6 5000 15/01/2020 0511361051130099032500091031300103 1005 Handball 6000 19/03/2020 1008 05184009103134009103740091 1340005 Cricket 11 15000 21/05/2020 033 200000315900513 LOUIS031153009031150903 31031130903913003 0313400903300903130010 CAPTAIN 03134009103134000910300903 30009103.137009101300 103 0300935 PID NAME GID 34001 031340091031340691 951349997 0151028 13134009103 Tanju 1300B 031540091 051309031340090040091340905 2 Semih 1008 3 Savas 1005 1300S03134009031500910313209103138009103130003 Cneyt 10031340091031340090303 30000313000130003 03134009105150ST 501031340103130609105366103134099031500910313009103 Take into account the two tables given above. 1240091000315400905100910313400905400 150003 write the SQL statements according to the statements from "a" to "d"91031540091057540091103 1540091 031340097 0913003103 write the outputs according to the statements from "e" to "h" (40 p.) 3154009101010313400911013154009151300703 0905150 1340031340091 051300010313409910100091 03154001 03 Show the name of all games. b. Show all the game information where their TrophyPrice is more than 8000. 40090009103134000 340091 134003 03 Show GameName, TrophyPrice / PlayerNums only for the game with its captain "Tanju" 2009 03 d. Increase the TrophyPrice by 1000 for "Football" and "Handball" 15400900031340009103.1300013 NET e. SELECT GameName FROM GAME WHERE TrophyPrice > SELECT MIN(TrophyPrice) FROM GAME; 03 f. SELECT GameName FROM ITEMS WHERE PlayerNums

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

Data Management Databases And Organizations

Authors: Watson Watson

5th Edition

0471715360, 978-0471715368

Students also viewed these Databases questions

Question

7. Explain why retirees may be valuable as part-time employees.

Answered: 1 week ago

Question

3. Provide advice on how to help a plateaued employee.

Answered: 1 week ago