fbpx

SQL

ERROR: syntax error

This error is a little bit more difficult to troubleshoot since it’s less specific. There’s 3 main things you need to look at when this … Read More

Foreign Keys

In JOIN, we stated that the flight_id field in the flights table was a primary key… JOIN airport.flights ON boarding_passes.flight_id = flights.flight_id; …what’s this mean … Read More

Primary Keys

In JOIN, we stated that the flight_id field in the flights table was a primary key… JOIN airport.flights ON boarding_passes.flight_id = flights.flight_id; …what’s this mean … Read More

Logical Operators

When learning WHERE, we utilized “AND”… WHERE star_rating >= 4 AND color = ‘Red’; …to filter for shirts that had a star_rating value of greater than … Read More

Comparison Operators

When learning WHERE, we utilized “>=”… WHERE star_rating >= 4; …to filter for shirts that had a star_rating value of greater than or equal to … Read More

What is SQL?

SQL explained As defined by W3Schools, a world-renowned web developer site… SQL (Structured Query Language) is a standard language for accessing and manipulating databases. SQL … Read More

ORDER BY

ORDER BY explained Remember lining up for attendance as a kid in elementary school? Let’s say we’ve got the following students in a classroom… …and … Read More

HAVING

HAVING explained Meet Mary, an avid runner and fitness guru. Mary is competing to be selected to participate in The Best Race Ever against 2 … Read More