lab-sql-7's People
Forkers
catarinamcbatista sogunmola drhech leamartinez1411 ernesto-yelamos cornettomlette bcarrero vikasrathi1992 ferrazzolidicreddo louiscostes ahmed-abdelmoteleb macarenagortazar gabrielescarrer danny88o haggarw3 jast92 loretolf horacioe14 lupocordero johalruiz polhervella oriolsauleda lucaciceu hubert-trasch student-ih-labs-and-stuff agathantavrazou gvcarbajal emiliawoldan myhaijay juliea1001 sanjamil felagund93 gbraaf p-fuster 1francisco1 gonszalo jecastrom ayselrasul zsborsos camille1992 davidvazquezrios pgatterbauer sabinagio-ironhack-labs mbastcast abakos21 dbsquare gebhard4 lydiaaboukhamis levside grovyle12 radhikagokhale phenomenonnk waxa2 maiapozzolo missadesola aravindendluri elnaz93 nicolasspettel agnesap itsmrn sergi-garriga victorpereztolosa tuko95 paulidl davidbayarri brucenzi lazaruskon sammyjrjr allabe93 vanchido emanuelpanait21 faezehsadatm prajwalita-b laurapujolassos gianpatti anusha-gillella thuyle1210 mariolatorre1 mattber93 chloeisabelle pedrohenriquegordo elliotec-data galrodri mog-rouhi mariyamyk yngridfiglioli isra-st sbgriwa isi-mube yinguin evangelos-z swap1688 andrepconde kirstygos andresm29 rachelleflores lj90pot oktaysadakda jpujolf95 sandraccrislab-sql-7's Issues
Task 9
Could not find a solution for task 9 that uses the tools learned so far (the suggested solution is not working, since alias and window functions are not supported in 'where' clauses). Workaround would be with subqueries, but it is a topic to be presented in the next unit.
Workaround:
select * from (select rental_id, inventory_id, datediff(return_date, rental_date) num_days, avg(datediff(return_date, rental_date)) over (partition by inventory_id) avg_return_days
from rental) as t
where t.num_days < t.avg_return_days;
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.