Insertar en Customers la compañía ‘Compañía XX’ con ‘Ana’, ‘Pi’ como contacto
1 2 | insert into customers (company,first_name,last_name)values ('Compañía XX','Ana','Pi') |
Modificar en Customer el campo email_address y poner ‘Sin email’
1 2 | update customersset email_address='Sin email' |
Eliminar el Customer con id = 20
1 2 | delete from customerswhere id=20 |
Seleccionar todos los proveedores (suppliers) cuyo trabajo sea ‘Sales Manager’
1 | SELECT * from suppliers where job_title='Sales manager' |
Seleccionar todos los pedidos (orders) de junio
1 2 | select * from orderswhere month(order_date)=6 |
Calcular el número de pedidos por cliente
1 2 | SELECT company,count(orders.id) total FROM customers left join orders on customers.id=orders.customer_idgroup by customers.id |
Calcular el total de ventas por empleado
1 2 3 | SELECT last_name,first_name,sum(quantity*unit_price*(1-discount)) total FROM employees join orders on employees.id=orders.employee_idjoin order_details on orders.id=order_details.order_idgroup by employees.id |
Averiguar el producto más caro
1 | SELECT * FROM `products` order by list_price desc limit 1 |
Averiguar el número de ventas por producto
1 2 | select products.*, sum(quantity*unit_price*(1-discount)) total from products join order_details on products.id= order_details.product_idgroup by products.id |
Mostrar los clientes con más de 10000 en ventas
1 2 3 4 | select customers.*, sum(quantity*unit_price*(1-discount)) total from customers join orders on customers.id= orders.customer_idjoin order_details on orders.id= order_details.order_idgroup by customers.idhaving total>10000 |
