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
ERROR: ambiguous column name
Ever been with a group of friends and two people are called “John”? And whenever someone calls for one of them, both of them respond? … Read More
ERROR: not a single-group function
Simply put, you forgot your GROUP BY statement. In GROUP BY, we discussed the golden rule of GROUP BY statements: “Whenever you have field(s) and … 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