Consultas SQL Server NorthwindDescripción completa
Exercises on Adjusting Entries for the ACCTBA1 course of De La Salle University.
CT069-3-3-DBS Database Security
Level 3
Exercises on Northwind Database Consider the schema of Northind database shon belo! belo!
"# $rite a %uery %uery to &et 'roduct 'roduct name name and %uantity(un %uantity(unit it )# $ri $rite te a %uery to &et current current 'roduct 'roduct list *'roduct *'roduct +D and name, name, 3# $ri $rite te a %uery to &et discontinued 'roduct 'roduct list *'roduct *'roduct +D and name, # $rite $rite a %uery to &et most e./ense e./ense and least e./ensive e./ensive 'roduct 'roduct list *name and unit /rice, # $rite $rite a %uery to &et 'roduct 'roduct list *id1 name1 unit /rice, /rice, here current current /roducts /roducts cost less than 2)0 6# $rite $rite a %uery to &et 'roduct 'roduct list *id1 name1 name1 unit /rice, here here /roducts /roducts cost beteen beteen 2" and 2) # $ri $rite te a %uery to &et 'roduct 'roduct list *name1 unit /rice, of above avera&e /rice 4# $ri $rite te a %uery to &et 'roduct 'roduct list *name1 unit /rice, of ten most e./ensive e./ensive /roducts /roducts 5sia 'acic 7niversity of Technolo&y 8 +nnovation )0"6
CT069-3-3-DBS Database Security
Level 3
9# $rite a %uery to count current and discontinued /roducts "0# $rite a %uery to &et 'roduct list *name1 units on order 1 units in stoc, of stoc is less
than the %uantity on order
5sia 'acic 7niversity of Technolo&y 8 +nnovation )0"6
