Week 4.md

SQl

• WHERE field1 LIKE 'Ch% - can be used for find all words with ch (Chavez and Chen)

SELECT all columns

with SELECT*

![[Pasted image 20230627165208.png]]

Commants

/* and */ 

Example of a query with aliases

![[Pasted image 20230627165350.png]] https://towardsdatascience.com/sql-cheat-sheet-776f8e3189fa https://www.w3schools.com/sql/default.asp