Week05-1

[zhamri]

Instructions:

1. Study the following SQL commands:
   • SQL UPDATE Statement
   • SQL ORDER BY Keyword
2. Go to Try-SQL Editor.
3. Choose table Customers.
4. Then:
   • Replace record No.3 with your information.
   • Display all customers from Malaysia, Mexico and Brazil by descending order.

Submission

1. All the related SQL commands.
2. Screenshot the results.

[mulyaidil]

Replace record No.3 with your information.

Display all customers from Malaysia, Mexico and Brazil by descending order.

[mimiothman]

UPDATE Customers SET CustomerName = 'Nor Syamimi Bt Othman', ContactName='Mimie', Address = 'Taman Guar Perahu', City='Bukit Mertajam', PostalCode = '14400' , Country = 'Malaysia' WHERE CustomerID=3;

SELECT * FROM Customers ORDER BY Country = 'Brazil' DESC;

SELECT * FROM Customers ORDER BY Country = 'Mexico' DESC;

SELECT * FROM Customers ORDER BY Country = 'Malaysia' DESC;

[roflinasuha]

UPDATE Customers SET CustomerName='Nurul Rofli Nasuha',ContactName='Rofli', City='Butterworth', Country='Malaysia',Address='Sungai lokan',PostalCode='13800' WHERE CustomerID=3;

SELECT * FROM Customers ORDER BY Country='Malaysia' DESC;

SELECT * FROM Customers ORDER BY Country='Mexico' DESC;

SELECT * FROM Customers ORDER BY Country='Brazil' DESC;

[hoong520]

TAN WEI HOONG 253701 UPDATE Customers SET CustomerName='TAN WEI HOONG',ContactName='HOONG', Address='KAMPUNG TIONG GEMAS',City='NEGERI SEMBILAN',PostalCode='73400',Country='Malaysia' WHERE CustomerID=3;

SELECT * FROM Customers ORDER BY Country='Malaysia' DESC;

SELECT * FROM Customers ORDER BY Country='Mexico' DESC;

SELECT * FROM Customers ORDER BY Country='Brazil' DESC;

[zongxu97]

1) UPDATE Customers SET CustomerName='LEE ZONG XU',ContactName='LEE SOO MAIN',Address='INAPAN SISWA SME BANK',City='CHANGLOON',PostalCode='16010',Country='MALAYSIA' WHERE CustomerID=3; 2) SELECT FROM Customers ORDER BY Country='MALAYSIA' DESC; 3) SELECT FROM Customers ORDER BY Country='Mexico' DESC; 4) SELECT * FROM Customers ORDER BY Country='Brazil' DESC;

[InasIbrahim]

UPDATE Customers SET CustomerName = 'Inas Nurshazdweeni Ibrahim', ContactName= 'Inas', Address= 'Taman Pulasan', City= 'Jitra', PostalCode= '06000', Country= 'Malaysia' WHERE CustomerID = 3;

SELECT * FROM Customers ORDER BY Country='Malaysia' DESC;

SELECT * FROM Customers ORDER BY Country='Mexico' DESC;

SELECT * FROM Customers ORDER BY Country='Brazil' DESC;

[khorchongseng]

UPDATE Customers SET Country='Malaysia', PostalCode = '040440' WHERE CustomerID=3; SELECT FROM Customers ORDER BY Country='Malaysia' DESC; SELECT FROM Customers ORDER BY Country='Mexico' DESC; SELECT * FROM Customers ORDER BY Country='Brazil' DESC

[effareenafasya]

UPDATE TABLE CUSTOMER

Display all customers from Malaysia, Mexico and Brazil by descending order.

[maziatulnazihah]

MAZIATUL NAZIHAH BINTI TASLEHAK@ISHAK 254222

1.UPDATE Customers SET CustomerName='Maziatul Nazihah',ContactName='Mai',Address='Segamat', City='Johor',PostalCode='85400',Country='Malaysia' WHERE CustomerID=3;

2.SELECT * FROM Customers ORDER BY Country = 'Brazil' DESC

3.SELECT * FROM Customers ORDER BY Country = 'Mexico' DESC

4.SELECT * FROM Customers ORDER BY Country = 'Malaysia' DESC

[WanEnNg]

**253629 Ng Wan En

1. Update** UPDATE Customers SET CustomerName = 'Ng Wan En', ContactName = 'Wan En', Address = '23,Lorong Asas Murni 6, Taman Asas Murni', City = 'Pulau Pinang', PostalCode= 14000, Country= 'Malaysia' WHERE CustomerID = 3;

2. Customers from Malaysia SELECT * FROM Customers ORDER BY Country ='Malaysia' DESC;

3. Customers from Mexico SELECT * FROM Customers ORDER BY Country ='Mexico' DESC;

4. Customers from Brazil SELECT * FROM Customers ORDER BY Country ='Brazil' DESC;

[anemrashid]

UPDATE MALAYSIA BRAZIL MEXICO

[adillanora97]

254318 Noradilla Binti Aidi Amin SELECT FROM Customers ORDER BY Country = 'Malaysia' DESC SELECT FROM Customers ORDER BY Country = 'Mexico' DESC SELECT * FROM Customers ORDER BY Country = 'Brazil' DESC

[ghost]

1. Replace record No.3 with your information.

UPDATE Customers SET CustomerName = 'Muhammad Nur Aysraf', ContactName = 'Nurasyraf', Address = 'Taman Tengku Maheran', City= 'Kedah.', PostalCode = '06000', Country = 'Malaysia' WHERE CustomerID = 3;

2. Display all customers from Malaysia, Mexico and Brazil by descending order.

SELECT * FROM Customers WHERE Country IN ('Malaysia', 'Mexico', 'Brazil') ORDER BY Country DESC;

[Khalidadzul]

[MengSin0524]

UPDATE Customers SET CustomerName = 'Choong Meng Sin', City = 'Ipoh',ContactName = 'Meng Sin', Country = 'Malaysia', Address = 'Taman Lpg Ria 2', PostalCode = '31650' WHERE CustomerID = 3; SELECT FROM Customers ORDER BY Country = 'Malaysia' DESC; SELECT FROM Customers ORDER BY Country = 'Mexico' DESC; SELECT * FROM Customers ORDER BY Country = 'Brazil' DESC;

[ShahrulFikriHamir]

Name: SHAHRUL FIKRI HAMIR No Matrix: 250812 UPDATE

UPDATE Customers SET CustomerName='Amir Izzat', ContactName='Shahrul Fikri Hamir', Address='No 13 Laluan Mewah Indah 11 Taman Mewah Indah', City='Batu Gajah', PostalCode='31000', Country='Malaysia' WHERE CustomerID='3';

SELECT BY ODER MALAYSIA SELECT * FROM Customers ORDER BY Country='Malaysia' DESC;

SELECT BY ODER MEXICO SELECT * FROM Customers ORDER BY Country='Mexico' DESC;

SELECT BY ODER BRAZIL SELECT * FROM Customers ORDER BY Country='Brazil' DESC;

[sitirahimah96]

update:

malaysia

mexico

brazil

[ainqurratul]

Replace record No.3 with your information UPDATE Customers SET CustomerName = 'Qurratul', ContactName= 'Ain', Address= 'SME BANK', City= 'Sintok', PostalCode= '06010', Country= 'Malaysia' WHERE CustomerID = 3;

Display all customers from Malaysia by descending order. SELECT * FROM Customers ORDER BY Country='Malaysia' DESC;

Display all customers from Mexico by descending order.

Display all customers from Brazil by descending order. SELECT * FROM Customers ORDER BY Country='Brazil' DESC;

[nurazieta98]

UPDATE Customers SET CustomerName='NUR AZIETA', ContactName='AZIETA', Address='Inasis Bank Muamalat', City='Sintok', PostalCode='06010', Country='Malaysia' WHERE CustomerID=3;

Malaysia desc

Mexico desc

Brazil desc

[NuriPuspitasari]

UPDATE Customers SET CustomerName = 'Nuri Puspitasari Binti Jafperi', ContactName='Nuri', Address = 'Jln Machang Limbat', City='Kota Bharu, Kelantan', PostalCode = '16150' , Country = 'Malaysia' WHERE CustomerID=3;

*SELECT FROM Customers WHERE Country IN ('Malaysia', 'Mexico', 'Brazil') ORDER BY Country DESC;**

[leezhanyi]

Lee Zhan Yi 254619 UPDATE Customers SET CustomerName = 'Lee Zhan Yi', ContactName= 'ZhanYi',Address='2,Jalan Teratai 59',City='Johor Bahru',PostalCode='81100',Country='Malaysia' WHERE CustomerID = 3;

SELECT * FROM Customers ORDER BY Country='Malaysia' DESC;

SELECT * FROM Customers ORDER BY Country = 'Brazil' DESC;

SELECT * FROM Customers ORDER BY Country = 'Mexico' DESC;

[chenyaushum]

TABLE CUSTOMERS

REPLACE NO.3 AS MY DETAILS UPDATE Customers SET CustomerName = 'Shum Chen Yau', ContactName = 'Yau', Address = 'A04-18, Jalan Austin Perdana 1', City = 'Johor Bahru', PostalCode = 81100, Country = 'Malaysia' WHERE CustomerID = 3;

Display all customers from Malaysia by descending order.

Display all customers from Mexico by descending order.

Display all customers from Brazil by descending order.

shumchenyau254854.docx

[ummuauzai]

UPDATE Customers SET CustomerName='Ummu Auzai',ContactName='Ummu',Address='Sungai Long', City='Selagor',PostalCode='32000',Country='Malaysia' WHERE CustomerID=3;

ORDER BY SELECT * FROM Customers WHERE Country IN ('Malaysia', 'Mexico', 'Brazil') ORDER BY Country DESC

[farahnabilah]

1) Replace record No.3 with your information. UPDATE Customers SET CustomerName='FARAH',ContactName='NABILAH', City='JOHOR', Country='Malaysia',Address='BUKIT GAMBIR',PostalCode='84800' WHERE CustomerID=3;

2) Display all customers from Malaysia, Mexico and Brazil by descending order.

SELECT * FROM Customers ORDER BY Country = 'Malaysia' DESC;

SELECT * FROM Customers ORDER BY Country = 'Mexico' DESC;

SELECT * FROM Customers ORDER BY Country = 'Brazil' DESC;

[syazlinazhar]

253920 Amiera Syazlin Md Azhar

1. Replace record No.3 with your information.

UPDATE Customers SET CustomerName = 'Amiera Syazlin Md Azhar', ContactName= 'Md Azhar', Address= '685, Jalan Seri Impian 1/3, Bandar Seri Impian', City= 'Kluang', PostalCode= '86000', Country= 'Malaysia' WHERE CustomerID = 3;

2. Display all customers from Malaysia, Mexico and Brazil by descending order.

a) Malaysia SELECT * FROM Customers ORDER BY Country= 'Malaysia' DESC;

b) Mexico SELECT * FROM Customers ORDER BY Country= 'Mexico' DESC;

c) Brazil SELECT * FROM Customers ORDER BY Country= 'Brazil' DESC;

[lausiewhung]

Replace record No.3 with your information. UPDATE Customers SET CustomerName='LAU SIEW HUNG',ContactName='YVONNE',Address='13,STREET ONE,SINTOK',City='KEDAH ',PostalCode='06010',Country='MALAYSIA' WHERE CustomerID = 3;

Display all customers from Malaysia, Mexico and Brazil by descending order. SELECT * FROM Customers ORDER BY Country ='MALAYSIA' DESC;

SELECT * FROM Customers ORDER BY Country ='Mexico' DESC;

SELECT * FROM Customers ORDER BY Country ='Brazil' DESC;

[chitramugil]

TABLE:UPDATE UPDATE Customers SET ContactName='Chitramugil',City='Klang',Country='Malaysia',Address='Taman Ria 4',PostalCode='42200',CustomerName='Chitramugil Raman' WHERE CustomerID = 3;

TABLE 2:ORDER BY SELECT * FROM Customers WHERE Country IN ('Malaysia', 'Mexico', 'Brazil') ORDER BY Country DESC

[syaziana]

Nurulsyaziana Fata (253819)

1. Replace record No.3 with your information:

2. Display all customers from Malaysia, Mexico and Brazil by descending order. SELECT * FROM Customers WHERE Country IN ('Malaysia', 'Mexico', 'Brazil') ORDER BY Country DESC

[Vjingwen]

Wang Jing Wen 253676 Replace record No.3 with your information: UPDATE Customers SET CustomerName = 'Wang Jing Wen', ContactName = 'Jing Wen', Address = 'Taman Kinrara', City= 'Selangor', PostalCode ='47100', Country = 'Malaysia' WHERE CustomerID = 3; Display all customers from Malaysia, Mexico and Brazil by descending order: SELECT * FROM Customers ORDER BY Country DESC;

[amirizzat57]

Amir Izzat 250774

1. Replace record No.3 with your information. UPDATE Customers SET CustomerName = 'Amir Izzat Bin Ahmad Shahabuddin', ContactName = 'Amir Izzat', Address = 'No 3711 Kampung Pak Kancil Dalam', City= 'Terengganu', PostalCode = '22100', Country= 'Malaysia' WHERE CustomerID = 3;

2. Display all customers from Malaysia, Mexico and Brazil by descending order. SELECT * FROM Customers ORDER BY Country='Malaysia' DESC;

SELECT * FROM Customers ORDER BY Country='Mexico' DESC;

SELECT * FROM Customers ORDER BY Country='Brazil' DESC;

[CojYee]

1. Replace record No.3 with your information SET CustomerName='Chng Ooi Jie Yee', ContactName='CojYee', Address='Dpp Proton', City='Penang', PostalCode='10460', Country='Malaysia' WHERE CustomerID=3;

2. Display all customers from Malaysia, Mexico and Brazil by descending order SELECT * FROM Customers WHERE Country IN ('Malaysia', 'Mexico', 'Brazil') ORDER BY Country DESC;

[fncscafred]

UPDATE Customers SET CustomerName = 'Francisca Frederick', ContactName = 'Frederick Frederline', Address = 'Mentari Court', City= 'Selangor', PostalCode ='46150', Country = 'Malaysia' WHERE CustomerID = 3;

SELECT * FROM Customers WHERE Country IN ('Malaysia', 'Mexico', 'Brazil') ORDER BY Country DESC;

[Syaqinahsafar]

UPDATE

ORDER

[maizatul98]

UPDATE Customers SET CustomerName= 'Maizatul Fatihah', ContactName= 'Syaqinah Safar', Address= 'Inasis SME Bank, UUM', City= 'Changlun', PostalCode=06010, Country= 'Malaysia' WHERE CustomerID = 3;

SELECT * FROM Customers WHERE Country IN ('Malaysia','Brazil','Mexico') ORDER BY Country DESC;

[nblhhda]

UPDATE Customers SET CustomerName = 'Ain Nabilah Huda bt Mat Taib', ContactName='Nabilah', Address = 'Taman Kuala Krau', City='Temerloh', PostalCode = '28050' , Country = 'Malaysia' WHERE CustomerID=3;

[nuruain]

Siti Nurul 'Ain Bt Mohamad Noor (254143)

1. Replace record No.3 with your information. SET CustomerName='Siti Nurul Ain',ContactName='Ain',Address='Baling', City='Kedah',PostalCode='09100',Country='Malaysia' WHERE CustomerID=3;

2. Display all customers from Malaysia, Mexico and Brazil by descending order. a) Malaysia SELECT * FROM Customers ORDER BY Country= 'Malaysia' DESC;

b) Mexico SELECT * FROM Customers ORDER BY Country= 'Mexico' DESC;

c) Brazil SELECT * FROM Customers ORDER BY Country= 'Brazil' DESC;

[muhammadnasyreeq]

[250795] Muhammad Nasyreeq Bin Nor Azam

UPDATE Customers SET CustomerName = 'Muhammad Nasyreeq Bin Nor Azam', ContactName='Nash', Address = 'Bandar Tasik Kesuma', City='Kajang', PostalCode = '43700' , Country = 'Malaysia' WHERE CustomerID=1;

SELECT * FROM Customers ORDER BY Country='Malaysia' DESC;

SELECT * FROM Customers ORDER BY Country='Mexico' DESC;

SELECT * FROM Customers ORDER BY Country='Brazil' DESC;

[Quitetve]

SQL UPDATE STATEMENT NO.3

SQL DESCENDING ORDER STATEMENT