This repository contains SQL scripts to create and populate tables for managing a radio network's operations, including stations, hosts, shows, partnerships, awards, and online presence.
StationID
: INT (Primary Key)StationName
: VARCHAR(255)Location
: VARCHAR(255)Frequency
: DECIMAL(5,2)LaunchDate
: DATE
HostID
: INT (Primary Key)HostName
: VARCHAR(255)ShowCount
: INTJoinDate
: DATE
ShowID
: INT (Primary Key)ShowName
: VARCHAR(255)HostID
: INT (Foreign Key referencing Hosts table)StationID
: INT (Foreign Key referencing Stations table)LaunchDate
: DATE
PartnershipID
: INT (Primary Key)PartnerName
: VARCHAR(255)PartnershipType
: VARCHAR(100)StartDate
: DATEEndDate
: DATE
ShowID
: INT (Foreign Key referencing Shows table)PartnershipID
: INT (Foreign Key referencing Partnerships table)
AwardID
: INT (Primary Key)AwardName
: VARCHAR(255)Year
: INTShowID
: INT (Foreign Key referencing Shows table)
PresenceID
: INT (Primary Key)PlatformName
: VARCHAR(255)Link
: VARCHAR(255)LaunchDate
: DATE
Sample data has been inserted into the tables to facilitate analysis and testing of SQL queries. Link - https://nitish2162001.github.io/Websitep/case2.html
SQL queries are provided within the SQL script for data retrieval and analysis.
- Retrieve all stations in the "East" region?
- List all shows hosted by "Vrajesh Hirjee"?
- Count the number of awards each show has won?
- Find shows that have partnerships with "Spotify"?
- Retrieve hosts who joined before 2010?
- List the shows and their launch dates in descending order of launch date?
- Find the total count of shows for each host?
- Show the online presence platforms with their links?
- Retrieve the stations in the "South" region launched after 2010?
- Rank hosts based on the number of shows they have hosted?
Feel free to explore the SQL scripts and data provided to understand the radio network's operations.