sqlparser

SELECT Name, ProductNumber, ListPrice AS Price
FROM Production.Product 
ORDER BY Name ASC;

sqlparser

SELECT Lastname, 
       Firstname 
INTO   Persons_backup 
FROM   Persons

sqlparser

  SELECT e.employee_id,
         e.last_name,
         e.department_id
  FROM   employees e, departments d
  WHERE  e.department_id = d.department_id 

sqlparser

SELECT p.Name, sod.SalesOrderID
FROM Production.Product AS p
LEFT OUTER JOIN Sales.SalesOrderDetail AS sod
ON p.ProductID = sod.ProductID

sqlparser

SELECT e.employee_id, 
       d.location_id  
FROM   employees e,departments d  
WHERE  e.department_id = d.department_id AND
       e.last_name = 'Matos';  

sqlparser

SELECT Subject, Semester, Count(*)
FROM [Subject_Selection]
GROUP BY Subject,Semester

sqlparser

SELECT Employees.LastName, COUNT(Orders.OrderID) AS NumberOfOrders FROM (Orders
INNER JOIN Employees
ON Orders.EmployeeID=Employees.EmployeeID)
GROUP BY LastName
HAVING COUNT(Orders.OrderID) > 10;

sqlparser

SELECT * FROM Customers
ORDER BY Country,CustomerName;

sqlparser

  SELECT SUM (Sales) FROM Store_Information
  WHERE Store_Name IN 
         (
           SELECT Store_Name FROM Geography
           WHERE Region_Name = 'West'
         );

sqlparser

INSERT INTO dbo.Points (PointValue) VALUES (CONVERT(Point, '3,4'));