Problem $50$

Write a query to display the invoice number, line numbers, product SKUs, product descriptions, and brand ID for sales of sealer and top coat products of the same brand on the same invoice. Sort the results by invoice number in ascending order, first line number in ascending order, and then by second line number in descending order $($Figure P$7\mathrm{.}50).$

INV$\_$NUM l$.$LINE$\_$NUM p$.$PROD$\_$SKU p$.$PROD$\_$DESCRIPT l$2.$LINE$\_$NUM p$2.$PROD$\_$SKU p$2.$PROD$\_$DESCRIPT BRAND$\_$ID

$11525140-$RTG Fire Resistant Sealer, for Exterior Wood $($ULC Approved$)11203-$AIS Fire Retardant Coating, Latex, Interior, Flat $($ULC Approved$)35$

$11825140-$RTG Fire Resistant Sealer, for Exterior Wood $($ULC Approved$)55046-$TTC Aluminum Paint, Heat Resistant $($Up to $427\backslash$deg C $-800\backslash$deg F$)35$

$13553036-$PCT Sealer, for Knots $21074-$VVJ Light Industrial Coating, Exterior, Water Based $($eggshell$-$like $-$ MPI Gloss Level $3)25$

$15323701-$YAW Sealer, Solvent Based, for Concrete Floors $13955-$NWD Water Repellant, Clear $($Not Paintable$)30$

$22211336-$FVM Alkyd, Sanding Sealer, Clear $38199-$YRF Varnish, Exterior, Water Based, $($Satin$-$Like$)$ MPI Gloss Level $433$

$23445728-$ZPO Shop Coat, Quick Dry, for Interior Steel $39272-$LTP Varnish, Marine Spar, Exterior, Gloss $($MPI Gloss Level $6)27$

$23445728-$ZPO Shop Coat, Quick Dry, for Interior Steel $29126-$PWF Latex, Recycled $($Consolidated$),$ Interior $($MPI Gloss Level $3)27$

$24314072-$SWV Sealer, Solvent Based, for Concrete Floors $35653-$RTU Aluminum Paint $23$

$28718894-$LUR Lacquer, Sanding Sealer, Clear $59838-$FUF Fire Retardant Top$-$Coat, Clear, Alkyd, Interior $($ULC Approved$)27$

$33313701-$YAW Sealer, Solvent Based, for Concrete Floors $62584-$CIJ Stain, for Exterior Wood Decks $30$