//SQL// Given this script select setseed(0.1234); create table observed_demand as ( select (cast(trunc(random() * 7) as
Posted: Sun Jul 03, 2022 11:23 am
//SQL//
Given this script
select setseed(0.1234);createtable observed_demand as (select (cast(trunc(random()* 7) as int))+ date '8/1/2013' as myDate ,cast(trunc(random()* 500 + 1) asint) as amountfrom generate_series(1,20)order by myDate);
Write a SQL query that will find the total demand on day'2013-08-05'
Given this script
select setseed(0.1234);createtable observed_demand as (select (cast(trunc(random()* 7) as int))+ date '8/1/2013' as myDate ,cast(trunc(random()* 500 + 1) asint) as amountfrom generate_series(1,20)order by myDate);
Write a SQL query that will find the total demand on day'2013-08-05'