Please write the SQL query to get the results above.I have following 7 given table schemas:bands_dimension: band_id / band_name / band_feepeople_dimension: person_id / person_nameperformance_dimension: performance_id / performance_startpurchase_dimension: purchase_id / purchase_dateticket_dimension: ticket_id / ticketnumvenues_dimension: venue_id / venue_name / capacityticket_sales_fact: band_id / venue_id / performance_id / ticket_id / person_id / ticket_price E. The AMD venue is where the music festival showcases up-and-coming bands. We want to identify those bands that sell out this venue because wemay want to sign them up to play in a bigger venue in next year's festival.Write a query that shows the performances that sold out this venue in the last five years, ordering them from most to least tickets sold. Note that thevenue allows Standing Room Only (SRO) tickets to be sold, so the number of tickets sold could exceed the venue's capacity (which is the number of seatsin the venue).10. Bands that sold out the AMD venue since 2018.venue_name band_nameAMDAMDAMDAMDAMDAMDAMDAMDAMDAMDRÜFÜS DU SOLThe TeetaPalm SpringsteenTame ImpalaWesley BrayARIZONABig ThiefFreya RidingsParquet CourtsTinasheyear2021202120192019201920182018201820182018capacity700700700700700700700700700700ticketssold750735716743707747764721732806

This query can be defined in such a way that it will first be part of the ticket_sales_fact table…

Answered: E. The AMD venue is where the music…

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

Related questions

Concept explainers

Question

Please write the SQL query to get the results above.

I have following 7 given table schemas:

bands_dimension: band_id / band_name / band_fee
people_dimension: person_id / person_name
performance_dimension: performance_id / performance_start
purchase_dimension: purchase_id / purchase_date
ticket_dimension: ticket_id / ticketnum
venues_dimension: venue_id / venue_name / capacity
ticket_sales_fact: band_id / venue_id / performance_id / ticket_id / person_id / ticket_price

E. The AMD venue is where the music festival showcases up-and-coming bands. We want to identify those bands that sell out this venue because we
may want to sign them up to play in a bigger venue in next year's festival.
Write a query that shows the performances that sold out this venue in the last five years, ordering them from most to least tickets sold. Note that the
venue allows Standing Room Only (SRO) tickets to be sold, so the number of tickets sold could exceed the venue's capacity (which is the number of seats
in the venue).
10. Bands that sold out the AMD venue since 2018.
venue_name band_name
AMD
AMD
AMD
AMD
AMD
AMD
AMD
AMD
AMD
AMD
RÜFÜS DU SOL
The Teeta
Palm Springsteen
Tame Impala
Wesley Bray
ARIZONA
Big Thief
Freya Ridings
Parquet Courts
Tinashe
year
2021
2021
2019
2019
2019
2018
2018
2018
2018
2018
capacity
700
700
700
700
700
700
700
700
700
700
tickets
sold
750
735
716
743
707
747
764
721
732
806

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions