BY : Shan-Chun Niki YANG

Table of Content

Introduction

I will use the following SQL commands in this analysis.

SELECT, FROM

AS, WHERE, AND, OR, LIKE, IS NULL, LIMIT, ORDER BY

COUNT, MIN, MAX, GROUP BY, HAVING

JOIN, LEFT JOIN, CROSS JOIN, WITH

<aside> 💡 Disclaimer: This is an extended exercise from the course Analyze Data with SQL on Cocademy. All data used here belongs to Cocademy.

</aside>

Context

The Codecademy Times (fictional) is a newspaper with two types of subscriptions:

• print newspaper
• online articles

Some users subscribe to just the newspaper, some subscribe to just the online edition, and some subscribe to both. These information is stored in the following tables :

• The newspaper table contains information about the newspaper subscribers.