please check attached tables
i need this for my studies i have a lot more very similar work
i need following sql commands
1.
select average amoung as AVG_Anzahl that 1 person has
i have no idea here
2.
select all konto as anzahl where min 1 buchung was performed
my attempt:
select count(*) as anzahl from konto inner join buchung on [login to view URL] = [login to view URL]
but its wrong it gives me 30 instead of 12
the next 3 i also dont know
3.
select name and gebdat (date of birth) where konto saldo > 10000
4.
select all buchungen where transferred amount ist greater than 1.5 * avg of all
5.
select all buchungen where affected inhaber (person) is older than 30 year = 360 months
affected means it can be vonkonto (fromaccount) and aufkonto (tooaccount)
use SYSDATE and ADD_MONTHS(d,m) for this task
transaltion
inhaber = person
anzahl = amount
konto = bankaccount
buchung = account transaction
I have downloaded the attached pdf and looked at the tables. I can do all 5 [login to view URL] database it should be, MYSQL, POSTGreSQL or Sql server? I will do it fast
$30 USD in 1 day
4.8 (103 reviews)
5.8
5.8
13 freelancers are bidding on average $26 USD for this job
lets start from now...ready to start work from now...lets start from now...ready to start work from now..lets start from now...ready to start work from now
Having 4+ Years of experience in Oracle MYSQL Database.
Have vast knowledge of Database.
Please have a look on my profile.
Currently working in Oracle Corporation.
Greetings,
I am BS-CS graduate having majors in Software Engineering. I have knowledge of Database and its application thus can write the queries accordingly and assist you. All work will be done in time by submitting updates periodically.
Hoping to hear soon from you to discuss more details.
I'm a fresher of B. Tech. in Computer Science & Engineering.I'm most reliable when it comes to Structured Query Language.I will certainly serve your purpose. Thank You.
Hi, i am Certified SQL developer. Lets just start.
I have seen through the tables you've shared and have already brainstormed your queries.
Lets agree.
Best,
Sherik- DataPlus1