A Brief Introduction To SQL

customersname    age  favorite_food  cityFred    34   apple          NY
Alex 44 broccoli NY
John 28 banana NY
John 24 walnut LA
Sarah 56 orange LA
SELECT name FROM customers>>>
Fred
Alex
John
John
Sarah
SELECT MAX(age) FROM customer>>>
56
SELECT city, MAX(age) FROM customers
GROUP BY city
>>>
NY 44
LA 56
SELECT name FROM customers 
WHERE age > 30
>>>
Fred
Alex
Sarah
SELECT name FROM customers
WHERE favorite_food == broccoli
>>>
Alex

--

--

--

Data scientist learning at Flat Iron School

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

How to refresh your daily dev environment?

Borderlands — TRYHACKME Writeup OSCP Style

How a C++ developer learns JavaScript: a frustrating but ultimately satisfying tale

Principles of MapReduce

A Guide to Load Testing via Locust

Kotlin Explained: Property delegation

8 Components You Need to Run Containers in Production

Customizing http.server module of Python core

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Datascience George

Datascience George

Data scientist learning at Flat Iron School

More from Medium

SQL Exercises 5 — Formatting Query Output

What is SQL and What are Databases?