Get your own SQL server

SQL Statement:

x
 
SELECT * FROM Customers WHERE (CustomerName LIKE 'L%'
OR CustomerName LIKE 'R%' /*OR CustomerName LIKE 'S%'
OR CustomerName LIKE 'T%'*/ OR CustomerName LIKE 'W%')
AND Country='USA'
ORDER BY CustomerName;
        

Edit the SQL Statement, and click "Run SQL" to see the result.

Result:

The Try-MySQL Editor
at w3schools.com

MySQL Database:
TablenamesRecords
Customers91
Categories8
Employees9
OrderDetails2155
Orders830
Products77
Shippers3
Suppliers29