SQL, HTML, CSS, JavaScript
No description yet. This curated deck is ready for daily study.
Card preview (10)
Write an SQL command to select everything from the table called customers
SELECT * FROM Customers
Write an SQL command to select everything in the column “Name” from the table Customers
SELECT Name FROM Customers
Write an SQL command to select the columns “Name” and “City” From the table Customers
SELECT Name, City FROM Customers
write an SQL command to select all info on entities in a table called Customers, where the column “Country” is “Sweden”
SELECT * FROM Customers WHERE Country = “Sweden”
In an SQL table called Products, write a command to list the ProductName and Price of all entities with a price greater than 50
SELECT Productname, Price FROM Products WHERE Price > 50
From the Table Suppliers, write an SQL command to select the SupplierName and Country where the country is Not germany
SELECT SupplierName, Country FROM Suppliers WHERE Country != “Germany”
SQL statement to show all the information for table Customers with the ContactName Thomas Hardy or LIz Nixon
SELECT * FROM Customers WHERE Contactname = “Thomas Hardy” OR Contactname = “Liz Nixon”
In the table Customers Show the name and country of all customers in paris or london
SELECT CustomerName, Country FROM Customers WHERE City = “London” OR City = “Paris”
list everything in the Table Products with CategoryID 1 and a price less than 10
SELECT * FROM Products WHERE CategoryID = 1 and Price < 10