I need to design a dataabse table that fits this report for a project for a sale
ID: 3662662 • Letter: I
Question
I need to design a dataabse table that fits this report for a project for a sales company
Pipeline means that open quotes
CPO means calls per hour metric
Thursday 1 Week 1/4-1 Calls Out CPMs CGO Appointments Total Pipeline Week Total Bookings 18 Current O Day Week Month Sales Rep Day Week Avg Day Week Avg Day Week Month Day Week Month Ben Jordan Sampson Hijar 49 193 48108 477119 1 29 | 153 | 38 | 99 | 471 | 118| 34 184 46 133 562 141 0 15 $1,766,967.00 0 S 1 S 36,960.00 14 575,683.00 0 S 9 914,043.00 0 S 0 0 Renewal Activity icole Mullineaux 1 $160,160.00 8 $219,290.00 59 $5,303,534.00 215,922.007 182,155.307 182,155.30Explanation / Answer
Creating database in SQL
SQL> CREATE DATABASE SALES_COMPANY
SQL> CREATE TABLE SALES(
datetime NOT NULL DEFAULT CURDATE()(
Sales_Rap CHAR (15)
);
CALLS_OUT(
Day INT
Week INT
Avg INT
);
CPMs(
Day INT
Week INT
Avg INT
);
CGO(
Day INT
Week INT
Month INT
);
Appontments(
Day INT
Week INT
Month INT
);
Total_Pipeline(
Day DECIMAL (18, 2),
Week DECIMAL (18, 2)
Month DECIMAL (18, 2)
);
Total_Bookings(
Day DECIMAL (18, 2),
Week DECIMAL (18, 2)
Month DECIMAL (18, 2)
);
);
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.