ID | Year | Total_Subscribers | Digital_Subscribers | Print_Subscribers |
---|---|---|---|---|
1 | 2022 | 10000 | 5000 | 5000 |
2 | 2023 | 15000 | 6000 | 9000 |
ID | Year | Unique_Visitors | Pageviews | Bounce_Rate |
---|---|---|---|---|
1 | 2022 | 20000 | 40000 | 0.75 |
2 | 2023 | 25000 | 50000 | 0.8 |
ArticleID | Title | Author | Category | PublishDate | WordCount |
---|---|---|---|---|---|
1 | The Impact of Climate Change on Agriculture | John Doe | Environment | 2024-03-13 18:06:58 | 1200 |
2 | Understanding the Quantum Computing Revolution | Jane Smith | Technology | 2024-03-13 18:06:58 | 1500 |
3 | The Rise of Renewable Energy Sources | Emma Johnson | Environment | 2024-03-13 18:06:58 | 1800 |
AuthorID | FirstName | LastName | Bio |
---|---|---|---|
1 | John | Doe | An environmental journalist with a passion for climate change. |
2 | Jane | Smith | A technology reporter who covers the latest advancements in the field. |
3 | Emma | Johnson | An experienced energy reporter focused on renewable sources. |
CategoryID | Name |
---|---|
1 | Politics |
2 | Economy |
ArticleID | AuthorID |
---|---|
(→ Articles.ArticleID) | (→ Authors.AuthorID) |
1 | 1 |
2 | 2 |
3 | 3 |