Schema used for the project

List of the tables in a schema called music_store_analysis.

Q1 What is the senior most employee based on job title?

Q2 Which countries have the most invoices?

Q3 What are the top 3 values of total invoices?

Q4. Which city has the best customers? We would ;ike to throw a promotional Music festival in the city we made the most money?

Write a query that returns one city that has the highest sum of invoice totals. Return both the city name and sum of all invoices totals.

Q5. Who is the best customer? The customer who has spent the most money will be the declared the best customer?

Write a query that returns the person who has spwnt the most money.

Q6. Write a query to return the email, first name, last name and genre of all Rock Music listeers?

Return your list ordered alphabetically by email starting with A