Loading...

Tables Example
Products: id, name, discount, created_at
Orders: id, product_id, user_id, created_at
Users: id, name, email, password, created_at
Query Examples
You can ask questions like below for example:

List the products with highest discounts.

Which user has placed most orders ?

Create a view to get users who have placed most orders.

Create a procedure to get products that have orders placed against them.

Create a before insert trigger for products.

Give me SQL query to select users with most orders.

select * from users limit 10