SQL, HTML, CSS, JavaScript

Question 1

Write an SQL command to select everything from the table called customers

Answer 1

SELECT *
FROM Customers

Question 2

Write an SQL command to select everything in the column “Name” from the table Customers

Answer 2

SELECT Name
FROM Customers

Question 3

Write an SQL command to select the columns “Name” and “City”
From the table Customers

Answer 3

SELECT Name, City
FROM Customers

Question 4

write an SQL command to select all info on entities in a table called Customers, where the column “Country” is “Sweden”

Answer 4

SELECT *
FROM Customers
WHERE Country = “Sweden”

Question 5

In an SQL table called Products, write a command to list the ProductName and Price of all entities with a price greater than 50

Answer 5

SELECT Productname, Price
FROM Products
WHERE Price > 50

Question 6

From the Table Suppliers, write an SQL command to select the SupplierName and Country where the country is Not germany

Answer 6

SELECT SupplierName, Country
FROM Suppliers
WHERE Country != “Germany”

Question 7

SQL statement to show all the information for table Customers with the ContactName Thomas Hardy or LIz Nixon

Answer 7

SELECT * FROM Customers
WHERE Contactname = “Thomas Hardy” OR Contactname = “Liz Nixon”

Question 8

In the table Customers

Show the name and country of all customers in paris or london

Answer 8

SELECT CustomerName, Country
FROM Customers
WHERE City = “London” OR City = “Paris”

Question 9

list everything in the Table Products with CategoryID 1 and a price less than 10

Answer 9

SELECT * FROM Products
WHERE CategoryID = 1 and Price < 10