Configure sql database
- or -
Post a project like this1780
£40(approx. $50)
- Posted:
- Proposals: 6
- Remote
- #2368912
- PRE-FUNDED
- Awarded
Description
Experience Level: Intermediate
Someone already has the data files, one is very large 2GB. I need to configure the database, perhaps using Amazon Web Services or another platform. Then to prepare queries. I have a sample query we can use to begin the development work:
select * from
(with paras as (select 46 as play_id, 20 as ceiling from dual),
wq as (select /*+ MATERIALIZE */ a0, count(*) as num_a0 from words w, paras where w.play_id != paras.play_id group by a0)
select w.a0 as lemma, listagg(w.w0, '; ') within group(order by w.w0) as words, sum(num_tokens) as num_tokens_in_play,
nvl((select num_a0 from wq
where wq.a0 = w.a0),0) as num_tokens_in_other_plays
from
(select a0, w0, sum(1) as num_tokens
from words w, paras
where w.play_id = paras.play_id
and a0 in
(select a0
from words w
where w.play_id = paras.play_id
group by a0 having count(*) <= paras.ceiling)
group by a0, w0) w
group by w.a0 order by w.a0)
order by num_tokens_in_play, lemma;
select * from
(with paras as (select 46 as play_id, 20 as ceiling from dual),
wq as (select /*+ MATERIALIZE */ a0, count(*) as num_a0 from words w, paras where w.play_id != paras.play_id group by a0)
select w.a0 as lemma, listagg(w.w0, '; ') within group(order by w.w0) as words, sum(num_tokens) as num_tokens_in_play,
nvl((select num_a0 from wq
where wq.a0 = w.a0),0) as num_tokens_in_other_plays
from
(select a0, w0, sum(1) as num_tokens
from words w, paras
where w.play_id = paras.play_id
and a0 in
(select a0
from words w
where w.play_id = paras.play_id
group by a0 having count(*) <= paras.ceiling)
group by a0, w0) w
group by w.a0 order by w.a0)
order by num_tokens_in_play, lemma;
Ken F.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
23 Apr 2019
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies