CS316-Databases-F17/CreateViews.sql at main · SamPease/CS316-Databases-F17 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
create view PledgeView(PLEDGE ID, NAME, CREATOR, BLURB, SLUG, STATE, URL) as
select PPLEDGE ID, NAME, CREATOR, BLURB, SLUG, STATE, URL
from Database_Table;

create view DateView(PLEDGE_ID,DEADLINE, CREATED, LAUNCHED) as
select PLEDGE_ID,DEADLINE, CREATED, LAUNCHED
from Database_Table;

create view AmountPledgedOutOfGoalView(PLEDGE ID, PLEDGED, GOAL) as
select PLEDGE ID, PLEDGED, GOAL
from Database_Table;

create view CreatorInfoView(CREATOR, LOCATION) as
select CREATOR, LOCATION
from Database_Table;

create view CommunityStandingView(PLEDGE ID, REGULAR, STAFF_PICK, STARRED, SPOTLIGHT, PLEDGED PERCENTAGE) as
select PLEDGE ID, not(STAFF_PICK or STARRED or SPOTLIGHT) as REGULAR, STAFF_PICK, STARRED, SPOTLIGHT, PLEDGED/GOAL as PLEDGED PERCENTAGE
from Database_Table;

create view IndustryView(CATEGORY, PLEDGED PERCENTAGE) as
select from CATEGORY, PLEDGED PERCENTAGE
from Database_Table;