Complex~37min
The Menu Illusion
The restaurant promotes its Truffle Pasta and Wagyu Burger as signature items — they're the most-ordered dishes. The restaurant is profitable despite these items, not because of them.
Tables you'll query
menu_itemsorder_itemscogs_dataorders
What you'll learn
CTEs (WITH clause)JOINsAggregations & GROUP BYCASE Statements