assessing knowledge of SQL, PostgreSQL
assessing knowledge of PostgreSQL, SQL
SQL | PostgreSQL | Music Store | Time function - Calculate the duration of all songs in each cd and output a list.
assessing knowledge of Logical thinking, SQL
assessing knowledge of SQL
SQL | PostgreSQL | Hotels - average prices - Prepare the report with the average prices in the cities.
assessing knowledge of Logical thinking, SQL
assessing knowledge of SQL
SQL | PostgreSQL | Hotels - bookings - Prepare the booking list with a number of days, price per day and total price of the stay.
assessing knowledge of Logical thinking, SQL
SQL | PostgreSQL | Hotels - cities and top hotels - Prepare a list of cities with the date of last reservation and a main photo (photos[0]) of the most popular (by number of bookings) hotel in this city.
assessing knowledge of Java, Spring Boot
assessing knowledge of PostgreSQL, SQL
Java | Spring Boot | Items Retriever Microservice - Implement a microservice to retrieve items from the shopping system.
assessing knowledge of SQL
assessing knowledge of SQL
SQL | PostgreSQL | Hotels - hotels page optimization - Improve the performance of the the hotels listing page which currently uses ORM.
assessing knowledge of SQL, MongoDB, NoSQL
assessing knowledge of MongoDB
SQL | Customer Data - Find all the customers whose first and last names are not unique in this database, as well as the number of times each first and last name pair appears in the database.
assessing knowledge of SQL, MySQL
SQL | Customer Data - Find all the customers whose first and last names are not unique in this database, as well as the number of times each first and last name pair appears in the database.
assessing knowledge of SQL
PostreSQL - Rewards Program - Write a query which will find the top 3 ranked customers according to the revenue they created with all of their orders
