What I learned this week - 15th May 2023
inaccessible-encryption-credentials
Spring IO
AWS Serverless Innovation
Spring GraphQL
Python TikTok
Netflix using Python - job posting
Angular Signals - https://www.freecodecamp.org/news/angular-signals/
Some SQL rewind
- Find number of movies each director has directed
SELECT Director, count(*) as 'no. of movies' FROM movies group by Director;
- Find the total domestic and international sales that can be attributed to each director
SELECT m.Director , sum(b.Domestic_sales + b.International_sales) as total_Sales FROM movies m JOIN Box_Office b ON m.Id = b.Movie_id group by Director;
Comments
Post a Comment