Several business questions were answered by querying the data in the MySQL database:
Which city museums are open on weekends (Both days)?
Identified museums that were open on both Saturday and Sunday based on their hours of operation.
Which canvas size costs the most?
Calculated the average price of paintings for each canvas size and identified the most expensive one.
Find top 10 most famous painting subjects based on availability.
Ranked subjects by their frequency in the database.
How many museums are open every single day?
Counted the number of museums with daily operation hours.
Who are the top 5 most popular artists?
Determined the most popular artists by counting the number of paintings they created.
Display the 3 least popular canvas sizes.
Identified the least frequently used canvas sizes.
Which museum is open for the longest during the day?
Compared the opening and closing hours of museums to find the longest operational hours.
Which museum has the most popular painting style?
Identified the museum with the highest number of paintings in the most popular style.
Identify the artists whose paintings are displayed in multiple countries.
Queried the work table and cross-referenced museum locations to find artists with international exposure.
Display the country and city with the most number of museums.
Aggregated data to identify countries and cities with the highest museum counts.
Identify the artist and the museum where the most expensive and least expensive paintings are placed.
Retrieved the artist and museum details for the paintings with the highest and lowest sale prices.
Display the artist name, sale price, painting name, museum name, museum city, and canvas label.
Detailed the artwork, its cost, and the museum for each painting.
Which are the 3 most popular and 3 least popular painting styles?
Ranked painting styles by the number of artworks associated with each.
Which artist has the most portraits outside the USA?
Focused on portrait works outside of the USA and identified the top artist in this category.