Latest

6/recent/ticker-posts

Use the following customer table and write the SQL query to select all fields from Customers where the country is NOT Germany and NOT USA.

 Use the following customer table and write the SQL query to select all fields from "Customers" where the country is NOT "Germany" and NOT "USA".





create table customers(
  customerId int,
  customerName varchar(255),
  contactName varchar(255),
  address varchar(255),
  city varchar(255),
  postalCode varchar(255),
  country varchar(255)
  );
insert into customers values (1,"alfreds futterkiste","maria anders","obere str. 57","berlin","12209","germany"),
  (2,"ana trujillo emparedadosy helados","ana trujillo","avda. de la constitucion 2222","mexico d.f.","5021","mexico"),
  (3,"antonio moreno taqueria","antonio moreno","mataderos 2312","mexico d.f.","5023","mexico"),
  (4,"around the horn","thomas hardy","120 hanover sq.","london","wa11dp","uk"),
  (5,"berglunds snabbkop","christina berglund","berguvsvagen 8","lulea","s-95822","sweden"),
  (6,"blauer see delikatessen","hanna moos","forsterstr. 57","mannheim","68306","germany"),
  (7,"blondel pere et fils","frederique citeaux","24, place kleber","strasbourg","67000","france"),
  (8,"bolido comidas preparadas","martin sommer","c/araquil,67","madrid","28023","spain"),
  (9,"bon app'","laurence lebihans","12,rue des bouchers","marseille","13008","france"),
  (10,"bottom-dollar marketse","elizabeth lincoln","23 tsawassen blyd","tsawssen","t2f8m4","canada"),
  (11,"b's beverages","victoria ashworth","fauntleroy circus","london","ec25nt","uk"),
  (12,"cactus comidas parallevar","patricio simpson","cerrito 333","buenos aires","1010","argentina"),
  (13, "centro comercial moctezuma","francisco chang","sierras de granada 9993","mexico d.f.","5022","mexico"),
  (14,"chop-suey chinese","yang wang","haupstr. 29","bern","3012","switzerland"),
  (15,"comercio mineiro","pedro afonso","av. dos lusiadas,23","sao paulo","05432043","brazil"),
  (16,"consolidated holdings","elizabeth brown","berkeley gardens 12 brewery","london","wx16lt","uk"),
  (17,"drachenblut delikatessend","sven ottlieb","waiserweg 21","aachen","52066","germany"),
  (18,"du monde entier","janine labrune","67, rue des cinquante otages","nantes","44000","france"),
  (19,"eastern connection","ann devon","35 king george","london","wx36fw","uk"),
  (20,"ernst handel","roland mendel","kirchgasse 6","graz","8010","austria");

select * from customers where not country="germany" and not country="usa";






Post a Comment

0 Comments