I need some help on queries. I need to create a calculated field in query form to add to my below create table statements. I would like to calcualte “days on current level” column from “date of current level” to today's date. Also I need some sort of trigger, or stored procedure to add, i'm blank on that one. If my existing statements are garbage, let me know as I'm always willing to learn better.

CREATE TABLE Customer (
PersonID int PRIMARY KEY,
FirstName varchar(255),
LastName varchar(255),
DateJoined Date,
Address varchar(255),
EMail varchar(255)
PhoneNumber varchar(255),
);
CREATE TABLE Subscription Status (
FreeorPaid varchar(255) PRIMARY KEY,
CustomerID# int,
DateJoined Date,
CurrentLevel int,
);
CREATE TABLE Progress On Levels (
CurrentLevel int PRIMARY KEY,
CustomerID# int,
DaysonCurrentLevel int,
AverageVisitspermonth int,
);

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now