Home > database >  With the users table and order list, new SQL check daily subscribers, the orders, the order number o
With the users table and order list, new SQL check daily subscribers, the orders, the order number o

Time:09-20

Has the following tables and fields:
User table: user, field: user_id, name, create_time,
Order table: order, field: order_id, user_id, create_time,
Please write a SQL statement, make a report, contains the following fields: date, number of new users, the orders, the order number of users
  • Related