n this assessment, students will show mastery over the use of Roll up, cube, and Grouping sets. Using the lobster farm d

[answerhappygod]

n this assessment, students will show mastery over the use ofRoll up, cube, and Grouping sets.
Using the lobster farm database, write a query to solve thefollowing request:
Andrea is doing a study for the Canadian Government. She wouldlike a single query that provides the following information:
Rules/Assumptions
Your submission must comply with the following list ofrules/assumptions. Violating the rules and assumptions willresult in a grade reduction and in some cases a zero on theassignment.