# data[].attributes.body
1.SELECT
SELECT Customer ID, Customer Nama,Country FROM Customers

2.SELECT CustomerName,Country   FROM Coustumer
WHERE Country='Mexico'
luljeta jaha "fehmi lladroci"

# data[].attributes.body
SELECT CostumerName,City,Country
FROM Costumers;

# data[].attributes.body
1.SELECT CustomerName,City FROM Customers;
2.SELECT * FROM Customers;
WHERE Country='Mexico'
Komanda insert into.

# data[].attributes.body
SELECT Customer ID, Customer Name,Country FROM Customers;

# data[].attributes.body
SELECT CustomerName,City FROM Customers;

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)VALUES ('Cardinal','Valon Aliaj','V.A','Adem Jashari','2000','Prizren');

# data[].attributes.body
SELECT CustomerName,City,Country FROM Customers;

# data[].attributes.body
SELECT CustomerName,City,Country FROM Customers;
_________________

ERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Albehar Shala','Albehar','Bazhderhane','Prizren','20000','Kosova');

# data[].attributes.body
Komanda SELECT
1.SELECT CustomersID,CustomerName,
Country FROM costumers;
Komanda Where
2.SELECT *
FROM Customers
WHERE Country IN ("Mexico");
Komanda Insert Into
1.INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES('Erza Berisha','Xhevat Berisha','Prizren',89' Kosove' )
Komanda DELETE
DELETE FROM Costumers
WHERE CustomerName='Erza' AND

# data[].attributes.body
1. SELECT CustomerID, CustomerName,Country FROM Customers;

2. SELECT  CustomerName,Country FROM Customers
WHERE Country='Mexico';

3. SELECT CustomerName,Country FROM Customers
WHERE Country IN ('Mexico')

4. INSERT INTO Customers ( CustomerID, CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('599','helolind','Aliaj','Hasan','Prizren','1998', 'Kosova');

# data[].attributes.body
1.SELECT
SELECT Customer ID, Customer Nama,Country FROM Customers

2.SELECT CustomerName,Country   FROM Coustumer
WHERE Country='Mexico'

Komanda Insert Into;
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES('Vjosa','Shala','Leka I madhe','Prizren','12','Kosove');

# data[].attributes.body
1.Komanda SELECT
SELECT CustomerID, CustomerName,Country FROM Customers;

2.Komanda WHERE
SELECT  CustomerName,Country
FROM Customers
WHERE Country='Mexico';

Komanda INSERT INTO
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Flamur Thaçi','Shefki'. '207','Prizren','2000','KOSOVO');

# data[].attributes.body
Komanda SELECT

1. SELECT CustomerID, CustomerName,Country FROM Customers;

2. SELECT  CustomerName,Country FROM Customers
WHERE Country='Mexico';

3. SELECT CustomerName,Country FROM Customers
WHERE Country IN ('Mexico');

4. SELECT CustomerName,Country FROM Customers

WHERE Country LIKE 'Mexico';

Komanda Instert Into

1. INSERT INTO Customers ( CustomerID, CustomerName, ContactName, Address, City, PostalCode, Country) VALUES ('599','Atdhe','Blerim','Dardania','Prizren','20000', 'Kosova');

Komanda DELETE

DELETE FROM Customers

WHERE CustomerID='599' AND CustomerName='Atdhe' AND ContactName='Blerim';

DELETE FROM Customers

WHERE  Address='Dardania' AND City='Prizren' AND PostalCode='20000' AND Country='Kosova';

Komanda Update
UPDATE Customers
SET City='Prishtina'
WHERE CustomerID=20;

UPDATE Customers
SET Address='Spitaliu'
WHERE CustomerID=200;

___________________________________________

# data[].attributes.body
1) Komanda Select
SELECT CostumersID,CostumerName
Contry FROM Costumers;

2) SELECT CostmerName Country From Contumers
WHERE Country 'Mexico';
3)Komanda INSERT INTO
INSERT INTO Costmuers (CostumerID
ContactName, City, PostalCode,Contry)

VALUES (8888','Qlirim Arifaj','Tiran D2, Prizren','12011','Kosovo');

# data[].attributes.body
1. Komanda Select
SELECT CustomerID, CustomerName, Country FROM customers ;

2. SELECT  CustomerName,Country FROM Customers
WHERE Country='Mexico';

3.Komanda INSERT INTO
INSERT INTO Customers (CustomerID, ContactName, Address, City, PostalCode, Country)
VALUES ('8888','Ermal Krasniqi','Tirana D2','Prizren','120211','Kosovo');

# data[].attributes.body
Komanda: SELECT

1. SELECT CustomerID,CustomerName,Country FROM Customers;

2. SELECT  CustomerName,Country FROM Customers
WHERE Country='Mexico';

3. SELECT CustomerName,Country FROM Customers
WHERE Country LIKE 'Mexico';

4. SELECT CustomerName,Country FROM Customers
WHERE Country IN ('Mexico');

5. INSERT INTO Customers (CustomerID, CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('379','Rinor','Avni','KrusheMadhe','Rahovec','20000','Kovovo');

_____________________________________

# data[].attributes.body
1 Komanda: Select  T(CustomerName,CustomerID,Country)
SELECT CustomerName,CustomerID,Country
FROM Customers;

2 From [XII9].[Te dhenat e nxensve
Where Country Vendilindja='Mexico'
3 INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('97','Blerim. Muhamet','Medvec2','Prizren','20000','Kosovo');