-- Store dates and times in SQL Server
CREATE TABLE TimeExperiment (
    a datetimeoffset,
    b datetimeoffset(0)
);

INSERT INTO TimeExperiment
    VALUES
        (getdate(), getdate())
;

SELECT * FROM TimeExperiment;

-- Dates and time values can be entered in a variety of ways
INSERT INTO TimeExperiment (a)
    VALUES
        ('2020-01-02'), -- Standard date format
        ('Jan 2, 2020'), -- Can also use text abbreviations
        ('2 January, 2020 14:25'), -- Combine date and time
        ('2 Jan, 2020 2:25 PM') -- Specify PM when entering afternoon times in 12 hour format
;

DROP TABLE TimeExperiment;

-- Store dates and times in PostgreSQL
CREATE TABLE TimeExperiment (
    a timestamp with time zone,
    b timestamp (0) with time zone
);

INSERT INTO TimeExperiment
    VALUES
        (now(), now())
;

SELECT * FROM TimeExperiment;

-- Dates and time values can be entered in a variety of ways
INSERT INTO TimeExperiment (a)
    VALUES
        ('2020-01-02'), -- Standard date format
        ('Jan 2, 2020'), -- Can also use text abbreviations
        ('2 January, 2020 14:25'), -- Combine date and time
        ('2 Jan, 2020 2:25 PM') -- Specify PM when entering afternoon times in 12 hour format
;

DROP TABLE TimeExperiment;

--- For PostgreSQL 
CREATE TABLE employees (
    first_name      CHARACTER VARYING (50),
    last_name       CHARACTER VARYING (100),
    phone_number    CHARACTER(8),
    office_number   CHARACTER (3),
    hire_date       DATE,
    annual_salary   NUMERIC (10,2) 
);

INSERT INTO employees
VALUES ('Adam', 'Wilbert','55-0123','201','2020-10-15',45000.00);

SELECT*FROM employees;

--- for SQL Server 
CREATE TABLE Employees (
    FirstName      VARCHAR (50),
    LastName       VARCHAR (100),
    PhoneNumber    CHAR(8),
    OfficeNumber   CHAR (3),
    HireDate       DATE,
    AnnualSalary   DECIMAL (10,2) 
);

INSERT INTO Employees
VALUES ('Adam', 'Wilbert','55-0123','201','2020-10-15',45000.00);

SELECT*FROM Employees;

-- SQL request(s)‌‌‌‌‌‌‌‌‌‌‌‌‌‌ below
-- Create your table here
CREATE TABLE EventSchedule (
    EventID         INTEGER PRIMARY KEY,         ---- 
    EventName       VARCHAR (100),
    VenueName       VARCHAR (100),
    MaxAttendees    SMALLINT,      
    TicketPrice     DECIMAL(6,2),
    EventDate       DATE,
    EventTime       TIME
);

------------------------------
-- Do not edit below this line
-- Include this insert and select statement in your final solution to test the table you've created above.

INSERT INTO EventSchedule (EventID, EventName, VenueName, MaxAttendees, TicketPrice, EventDate, EventTime)
VALUES
(1, 'The Midnight Echo', 'Luna Lounge', 150, 25.00, '2024-10-15', '20:00'),
(2, 'Neon Horizon', 'The Electric Owl', 200, 30.00, '2024-11-05', '21:00'),
(3, 'Echoes of the City', 'Sunset Plaza', 100, 20.00, '2024-12-01', '19:30'),
(4, 'The Velvet Nights', 'Moonlight Tavern', 180, 35.00, '2024-10-28', '20:30'),
(5, 'Solar Flare', 'Starlight Arena', 250, 40.00, '2024-11-20', '22:00');

SELECT * FROM EventSchedule