Logo

1st sem AY 2023-2024

Advance Web Development: Back End

BSIT 4

Sison, Michelle L.
MENU
1. Retrieve the customer names and contact information of all customers who have placed an order.
Customer Name Contact Name
Wilman KalaMatti Karttunen
Tradiçăo HipermercadosAnabela Domingues
Hanari CarnesMario Pontes
Victuailles en stockMary Saveley
Supręmes délicesPascale Cartrain
Hanari CarnesMario Pontes
Chop-suey ChineseYang Wang
Richter SupermarktMichael Holz
Wellington ImportadoraPaula Parente
HILARIÓN-AbastosCarlos Hernández
Ernst HandelRoland Mendel
Centro comercial MoctezumaFrancisco Chang
Old World DelicatessenRene Phillips
Que DelíciaBernardo Batista
Rattlesnake Canyon GroceryPaula Wilson
Ernst HandelRoland Mendel
Folk och fä HBMaria Larsson
Blondel pčre et filsFrédérique Citeaux
Wartian HerkkuPirkko Koskitalo
FrankenversandPeter Franken
GROSELLA-RestauranteManuel Pereira
White Clover MarketsKarl Jablonski
Wartian HerkkuPirkko Koskitalo
Split Rail Beer & AleArt Braunschweiger
Rattlesnake Canyon GroceryPaula Wilson
QUICK-StopHorst Kloss
Vins et alcools ChevalierPaul Henriot
Magazzini Alimentari RiunitiGiovanni Rovelli
Tortuga RestauranteMiguel Angel Paolino
Morgenstern GesundkostAlexander Feuer
Berglunds snabbköpChristina Berglund
Lehmanns MarktstandRenate Messner
Berglunds snabbköpChristina Berglund
Romero y tomilloAlejandra Camino
Romero y tomilloAlejandra Camino
LILA-SupermercadoCarlos González
Lehmanns MarktstandRenate Messner
QUICK-StopHorst Kloss
QUICK-StopHorst Kloss
Ricardo AdocicadosJanete Limeira
Reggiani CaseificiMaurizio Moroni
B's BeveragesVictoria Ashworth
Comércio MineiroPedro Afonso
Que DelíciaBernardo Batista
Tradiçăo HipermercadosAnabela Domingues
Tortuga RestauranteMiguel Angel Paolino
Rattlesnake Canyon GroceryPaula Wilson
Vins et alcools ChevalierPaul Henriot
LILA-SupermercadoCarlos González
Blondel pčre et filsFrédérique Citeaux
Hungry Owl All-Night GrocersPatricia McKenna
Ricardo AdocicadosJanete Limeira
Magazzini Alimentari RiunitiGiovanni Rovelli
Die Wandernde KuhRita Müller
Supręmes délicesPascale Cartrain
Godos Cocina TípicaJosé Pedro Freyre
Tortuga RestauranteMiguel Angel Paolino
Old World DelicatessenRene Phillips
Romero y tomilloAlejandra Camino
Lonesome Pine RestaurantFran Wilson
Ana Trujillo Emparedados y heladosAna Trujillo
Hungry Owl All-Night GrocersPatricia McKenna
The Big CheeseLiz Nixon
Du monde entierJanine Labrune
Die Wandernde KuhRita Müller
QUICK-StopHorst Kloss
Rattlesnake Canyon GroceryPaula Wilson
Island TradingHelen Bennett
Rattlesnake Canyon GroceryPaula Wilson
Lonesome Pine RestaurantFran Wilson
Island TradingHelen Bennett
Tortuga RestauranteMiguel Angel Paolino
Wartian HerkkuPirkko Koskitalo
Island TradingHelen Bennett
Pericles Comidas clásicasGuillermo Fernández
Königlich EssenPhilip Cramer
Save-a-lot MarketsJose Pavarotti
Königlich EssenPhilip Cramer
Bólido Comidas preparadasMartín Sommer
Folk och fä HBMaria Larsson
Furia Bacalhau e Frutos do MarLino Rodriguez
Split Rail Beer & AleArt Braunschweiger
LILA-SupermercadoCarlos González
Bon app'Laurence Lebihans
Mčre PaillardeJean Fresničre
Wartian HerkkuPirkko Koskitalo
Victuailles en stockMary Saveley
Hungry Owl All-Night GrocersPatricia McKenna
Princesa Isabel VinhossIsabel de Castro
FrankenversandPeter Franken
Old World DelicatessenRene Phillips
Mčre PaillardeJean Fresničre
Bon app'Laurence Lebihans
Simons bistroJytte Petersen
FrankenversandPeter Franken
Lehmanns MarktstandRenate Messner
White Clover MarketsKarl Jablonski
QUICK-StopHorst Kloss
Rattlesnake Canyon GroceryPaula Wilson
Familia ArquibaldoAria Cruz
Die Wandernde KuhRita Müller
Split Rail Beer & AleArt Braunschweiger
La maison d'AsieAnnette Roulet
Ernst HandelRoland Mendel
Furia Bacalhau e Frutos do MarLino Rodriguez
Piccolo und mehrGeorg Pipps
Pericles Comidas clásicasGuillermo Fernández
Around the HornThomas Hardy
Die Wandernde KuhRita Müller
LILA-SupermercadoCarlos González
La maison d'AsieAnnette Roulet
Seven Seas ImportsHari Kumar
Blondel pčre et filsFrédérique Citeaux
QUICK-StopHorst Kloss
Bon app'Laurence Lebihans
Drachenblut DelikatessendSven Ottlieb
Eastern ConnectionAnn Devon
Antonio Moreno TaqueríaAntonio Moreno
Galería del gastrónomoEduardo Saavedra
VaffeljernetPalle Ibsen
Ernst HandelRoland Mendel
Split Rail Beer & AleArt Braunschweiger
Chop-suey ChineseYang Wang
La maison d'AsieAnnette Roulet
Queen CozinhaLúcia Carvalho
Hungry Owl All-Night GrocersPatricia McKenna
WolskiZbyszek
Hungry Coyote Import StoreYoshi Latimer
Mčre PaillardeJean Fresničre
Seven Seas ImportsHari Kumar
Folk och fä HBMaria Larsson
Que DelíciaBernardo Batista
Hungry Owl All-Night GrocersPatricia McKenna
LILA-SupermercadoCarlos González
Ernst HandelRoland Mendel
Around the HornThomas Hardy
Berglunds snabbköpChristina Berglund
Split Rail Beer & AleArt Braunschweiger
Familia ArquibaldoAria Cruz
Santé GourmetJonas Bergulfsen
Seven Seas ImportsHari Kumar
Bottom-Dollar MarketseElizabeth Lincoln
Ernst HandelRoland Mendel
Drachenblut DelikatessendSven Ottlieb
Piccolo und mehrGeorg Pipps
Save-a-lot MarketsJose Pavarotti
Hungry Coyote Import StoreYoshi Latimer
HILARIÓN-AbastosCarlos Hernández
FrankenversandPeter Franken
Princesa Isabel VinhossIsabel de Castro
Save-a-lot MarketsJose Pavarotti
VaffeljernetPalle Ibsen
Eastern ConnectionAnn Devon
Rattlesnake Canyon GroceryPaula Wilson
Ernst HandelRoland Mendel
Ernst HandelRoland Mendel
Magazzini Alimentari RiunitiGiovanni Rovelli
LINO-DelicatesesFelipe Izquierdo
Queen CozinhaLúcia Carvalho
Ottilies KäseladenHenriette Pfalzheim
Folies gourmandesMartine Rancé
Océano Atlántico Ltda.Yvonne Moncada
Bottom-Dollar MarketseElizabeth Lincoln
Bottom-Dollar MarketseElizabeth Lincoln
Wartian HerkkuPirkko Koskitalo
La maison d'AsieAnnette Roulet
Familia ArquibaldoAria Cruz
Hungry Coyote Import StoreYoshi Latimer
Wartian HerkkuPirkko Koskitalo
Simons bistroJytte Petersen
QUICK-StopHorst Kloss
Richter SupermarktMichael Holz
Wellington ImportadoraPaula Parente
Que DelíciaBernardo Batista
Franchi S.p.A.Paolo Accorti
Gourmet LanchonetesAndré Fonseca
Mčre PaillardeJean Fresničre
La maison d'AsieAnnette Roulet
Galería del gastrónomoEduardo Saavedra
Piccolo und mehrGeorg Pipps
Reggiani CaseificiMaurizio Moroni
Hungry Owl All-Night GrocersPatricia McKenna
Ernst HandelRoland Mendel
Bottom-Dollar MarketseElizabeth Lincoln
Split Rail Beer & AleArt Braunschweiger
Princesa Isabel VinhossIsabel de Castro
Folk och fä HBMaria Larsson
Consolidated HoldingsElizabeth Brown
Blondel pčre et filsFrédérique Citeaux
Wartian HerkkuPirkko Koskitalo
Toms SpezialitätenKarin Josephs
Mčre PaillardeJean Fresničre
Save-a-lot MarketsJose Pavarotti
Old World DelicatessenRene Phillips
Ernst HandelRoland Mendel
Reggiani CaseificiMaurizio Moroni
2. List all customers and its ordered products with its price and quantity from the country Sweden.
Customer NameProduct NamePriceQuantity
Folk och fä HBChang1935
Folk och fä HBJack's New England Clam Chowder1025
Berglunds snabbköpGula Malacca1916
Berglunds snabbköpRaclette Courdavault5515
Berglunds snabbköpVegie-spread448
Berglunds snabbköpRöd Kaviar1525
Berglunds snabbköpGuaraná Fantástica512
Berglunds snabbköpPâté chinois2420
Berglunds snabbköpRhönbräu Klosterbier830
Folk och fä HBChang1925
Folk och fä HBQueso Cabrales2150
Folk och fä HBNord-Ost Matjeshering2635
Folk och fä HBEscargots de Bourgogne1330
Folk och fä HBFlřtemysost226
Berglunds snabbköpSir Rodney's Marmalade8128
Berglunds snabbköpCamembert Pierrot3415
Folk och fä HBQueso Cabrales216
Folk och fä HBLakkalikööri1818
3. List all customers that have ordered "Tofu" product.
Customer Name
Tradiçăo Hipermercados
Königlich Essen
Wartian Herkku
Hungry Coyote Import Store
Save-a-lot Markets
Océano Atlántico Ltda.
Wartian Herkku
Piccolo und mehr
4. List all products ordered by customers from Switzerland.
Product Name
Guaraná Fantástica
Pâté chinois
Longlife Tofu
Chang
Pavlova
Inlagd Sill
Raclette Courdavault
Wimmers gute Semmelknödel
Longlife Tofu
Camembert Pierrot
Gudbrandsdalsost
5. Identify the customers who have not placed any orders.
Customer Name
Blauer See Delikatessen
Cactus Comidas para llevar
FISSA Fabrica Inter. Salchichas S.A.
France restauration
Great Lakes Food Market
La corne d'abondance
Laughing Bacchus Wine Cellars
Lazy K Kountry Store
Let's Stop N Shop
Maison Dewey
North/South
Paris spécialités
Rancho grande
Spécialités du monde
The Cracker Box
Trail's Head Gourmet Provisioners
Alfreds Futterkiste

Submitted by: SISON, MICHELLE L.
Submitted to: MR. JIM-MAR DELOS REYES