Advanced SQL queries
By following this recipe, we will learn how to use advanced SQL statements such as INNER JOIN, COUNT, LIKE, DISTINCT, and so on.
How to do it…
You can do a lot more than just perform simple queries of SQL database:
First of all, we need to add a few tables to our database before we can dive into the programming part. Open up your web browser and access your phpMyAdmin. We need several tables for this example to work:

Next, we also have an
employeetable, which stores the information of all the employees in the dummy company. This table is similar to the...