🚀 ລະບົບປະມວນຜົນ SQL

ປ້ອນຄຳສັ່ງ ຫຼື ຄລິກຊື່ຕາຕະລາງເພື່ອເບິ່ງຂໍ້ມູນ

📊 ໂຄງສ້າງຕາຕະລາງ

📋 categories
  • 🔹 category_id (int)
  • 🔹 category_name (varchar(100))
📋 customers
  • 🔹 customer_id (int)
  • 🔹 first_name (varchar(50))
  • 🔹 last_name (varchar(50))
  • 🔹 email (varchar(100))
📋 order_items
  • 🔹 item_id (int)
  • 🔹 order_id (int)
  • 🔹 product_id (int)
  • 🔹 quantity (int)
  • 🔹 unit_price (decimal(10,2))
📋 orders
  • 🔹 order_id (int)
  • 🔹 order_date (datetime)
  • 🔹 customer_id (int)
  • 🔹 total_amount (decimal(10,2))
📋 products
  • 🔹 product_id (int)
  • 🔹 product_name (varchar(100))
  • 🔹 price (decimal(10,2))
  • 🔹 stock (int)
  • 🔹 category_id (int)

💻 ຂຽນຄຳສັ່ງ SQL