Small Projects

Identifying Uninteresting Facebook Pages

Skills Highlights:

JOIN, NULL, ORDER BY

## Through troubleshooting I identified that the Table “Pages_likes” was mislabeled and “Page_likes” was the correct name of the table! This emphasizes why it is so important to clearly label your identifiers and document them!

Source: Dataford.io

Identifying Top Traders

Skills Highlights:

JOIN, NULL, ORDER BY, GROUP BU, LIMIT, COUNT

This prompt requests the top 3 cities for trading. A fairly straightforward request, we can add multiple filters to get a simple answer: San Francisco, Boston, and Denver (respectively).

## Notice San Francisco has more than the 2nd and 3rd cities combined. I would visually emphasize this information to the team/requestor, as it likely will influence their goal.

Source: Dataford.io

Comparing Salaries by Education

Skills Highlights:

DISTINCT, Aliases, aggregate functions, ROUND, GROUP BY, ORDER BY

Source: Dataford.io

Identifying Duplicates

Skills Highlights:

COUNT, HAVING, operators

## I took the liberty of adding in the job title (Job_id), company identifier (Company_id), and the job description (Description) to the query because we can reasonably assume whoever asked for this query wants to identify who is submitting duplicate posts, which roles may be receiving duplicate or concurrent submissions, and if any job descriptions match similar postings with different titles!

Source: Dataford.io