Tables in this practice shop

• customers
  customer_id, first_name, last_name, city, joined_on, loyalty_tier
• products
  product_id, name, category, unit_price
• orders
  order_id, customer_id, order_date, channel
• order_items
  order_item_id, order_id, product_id, quantity