The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
DB name: FUNTHINGSDB
FUNTHINGSDB.ITEMS Table Description
Column Name Null Type
ITEM_ID NOT NULL NUMBER
ITEM_LOCATION NOT NULL VARCHAR2(40)
ITEMNAME NOT NULL VARCHAR2(100)
ITEM_COUNT NOT NULL NUMBER
DAYTIMESTAMP NOT NULL DATE
need a jsp page that async queries the previous db to output tables based on user input grouping view by time span(day,week, month, year ) and (ITEM_LOCATION) for each ITEM per ITEM_COUNT..
so table is count over time given the time span and grain based on that time span.
for a month a table with 4 entries of the difference in count between each week.
do all queries results based on the difference on item count per grain.
so if per week - query each day for week and display differences of their counts per day.
for two days example data :(same order as table above)
Sign in or Register to see more