I need the code for this problem in SQL. DO NOT USE 

•Cartesian Product (use a JOIN instead)
• TOP
• DATENAME()
• DATEPART()
• EXISTS
• NOT EXISTS
• CONVERT
• CAST
• COALESCE
• RETURN
• THROW
• TRY...CATCH
• Subquery in SELECT
• Subquery in HAVING
• Correlated subqueries of any kind

Based on the Concert data model handout. The system contains the rental fee for each venue and the number of seats (capacity) of each venue. The promoter wants to know how that converts to rental fee per seat for concerts that are not producing much revenue. Write a query to display the venue name and the per seat fee, where the per seat fee is the rental fee divided by the number of seats, for venues that have never had a concert that produced over $1,000,000 in revenue.