Please complete the following questions using SQL code. Thank you!

Question 1: Using an EXPLICIT JOIN, create a query that returns a list of companies that have an inaccurate percent of ownership. Meaning, store ownership can be split amoung many owners but the total of the percent should add up to 100%. You are to find any stores that break this rule. Return the companyName and [totalPercent]. Order the list by totalPercent and use "NEW SCHOOL" notation for naming your totalPercent field

Question 2: Using an EXPLICIT JOIN, create a query that returns EVERY store and the count of the number of movies each store has. Return only the storeId and the count of movies (named movieCount). Use "OLD SCHOOL" notation for naming the movieCount field. Order by storeId.