A select statement with that includes at least two aggregate functions

A select statement that uses at least one join, concatenation, and distinct clause

A select statement that includes at least one subquery

A select statement that uses an order by clause

An insert statement that runs a trigger in which the trigger adds data or updates data in a table

A delete statement that runs a trigger in which the trigger deletes data in one table.

$```$

$--$ User Table

CREATE TABLE User $($

user$\_$id VARCHAR$(255)$ PRIMARY KEY, $--$ Unique identifier for the user

email VARCHAR$(255)$ NOT NULL UNIQUE, $--$ User's email address

created$\_$time DATETIME NOT NULL, $--$ When the user account was created

password VARCHAR$(255)$ NOT NULL, $--$ User's password $($hashed$)$

display$\_$name VARCHAR$(255),--$ Display name for the user

phone$\_$number VARCHAR$(15),--$ User's phone number

is$\_$admin BOOLEAN DEFAULT $0$ COMMENT $\text{'}0=$ Non$-$Admin, $1=$ Admin' $--$ Role indicator

$)$;

$--$ Admin Table

CREATE TABLE Admin $($

admin$\_$id VARCHAR$(255)$ PRIMARY KEY, $--$ Unique identifier for the admin

user$\_$id VARCHAR$(255)$ NOT NULL UNIQUE, $--$ References a User who is an Admin

created$\_$at DATETIME NOT NULL, $--$ When the admin privileges were granted

can$\_$manage$\_$calendars BOOLEAN DEFAULT $0$ COMMENT 'Permission to manage calendars',

can$\_$manage$\_$events BOOLEAN DEFAULT $0$ COMMENT 'Permission to manage events',

FOREIGN KEY $($user$\_$id$)$ REFERENCES User$($user$\_$id$)--$ Foreign key to User table

$)$;

$--$ Calendar Table

CREATE TABLE Calendar $($

calendar$\_$id VARCHAR$(255)$ PRIMARY KEY, $--$ Unique identifier for the calendar

calendar$\_$name VARCHAR$(255)$ NOT NULL, $--$ Descriptive name of the calendar

created$\_$at DATETIME NOT NULL, $--$ When the calendar was created

created$\_$by VARCHAR$(255)$ NOT NULL, $--$ References the Admin who manages this calendar

FOREIGN KEY $($created$\_$by$)$ REFERENCES Admin$($admin$\_$id$)--$ Foreign key to Admin table

$)$;

$--$ Event Table

CREATE TABLE Event $($

event$\_$id VARCHAR$(255)$ PRIMARY KEY, $--$ Unique identifier for the event

start$\_$time DATETIME NOT NULL, $--$ Start time of the event

end$\_$time DATETIME NOT NULL, $--$ End time of the event

description VARCHAR$(255)$ NOT NULL, $--$ Description of the event

day$\_$of$\_$week VARCHAR$(15),--$ Day of the week $($optional$)$

CHECK $($start$\_$time $$ end$\_$time$)--$ Constraint to ensure event times are valid

$)$;

$--$ Calendar$\_$Event Table $($Many$-$to$-$Many Relationship$)$

CREATE TABLE Calendar$\_$Event $($

calendar$\_$id VARCHAR$(255),--$ References the Calendar table

event$\_$id VARCHAR$(255),--$ References the Event table

PRIMARY KEY $($calendar$\_$id$,$ event$\_$id$),--$ Composite primary key

FOREIGN KEY $($calendar$\_$id$)$ REFERENCES Calendar$($calendar$\_$id$),--$ Foreign key to Calendar table

FOREIGN KEY $($event$\_$id$)$ REFERENCES Event$($event$\_$id$)--$ Foreign key to Event table

$)$;

$```$