Week 2A – SQL and R

Overview

This assignment demonstrates the use of SQL and R to analyze data.
It includes loading a dataset, exploring its structure, and summarizing key variables.

set.seed(123)

ratings <- data.frame(
  item = paste("Item", 1:10),
  rating = sample(1:5, 10, replace = TRUE)
)

ratings

##       item rating
## 1   Item 1      3
## 2   Item 2      3
## 3   Item 3      2
## 4   Item 4      2
## 5   Item 5      3
## 6   Item 6      5
## 7   Item 7      4
## 8   Item 8      1
## 9   Item 9      2
## 10 Item 10      3