tomorrow I have final sql exam, luckily I already did the course in sololearn.... :) :) Wish me luck

Question

I leave you something fun...
select f.nro_factura, fecha, nom_vendedor+ ', ' +ape_vendedor, ape_cliente + ', ' + nom_cliente
Cliente,
descripcion, cantidad, cantidad*a.pre_unitario
from facturas f join vendedores v
on f.cod_vendedor = v.cod_vendedor
join clientes c on f.cod_cliente = c.cod_cliente
join detalle_facturas d on f.nro_factura = d.nro_factura
join articulos a on a.cod_articulo = d.cod_articulo
where year(fecha) in (2006, 2007)
and month(fecha) in (2, 3)
and descripcion like '[a-m]%'
order by fecha, ape_cliente + ', ' + nom_cliente, descripcion

Answer 1

select b.Answer
from BRAIN b
join QUESTION q
on b.Fact = q.Text 😉

Answer 2

Good Luck!

Answer 3

Good Luck!

Answer 4

all the best 👍

Answer 5

All the best!!!

Answer 6

Good luck

Answer 7

Good luck, all the best!

Answer 8

Gracias gente! :)

Answer 9

good luck. i think you will get high score from exam

Answer 10

Good luck .hope u can break ur record

Answer 11

Good luck!

Answer 12

Good luck 👍