I am using the Sakila Database for practice. I am calculating - Sales by Store. It provides a list of total sales, broken down by store. It incorporates data from the city, country, payment, rental, inventory, store, address, and staff…
I have db on MySQL - dataset with users actions logs. We have next data collection logic - every user have it own user_id and we record log of event actions during user session. user_id session_id dateTime event 1 aa…
I am learning to use groupBy. In my exercise, I must count the number of tickets that were sold and add the total money collected. $tickets = Ingresostaquilla::groupBy('tipo') ->selectRaw('count(*) as quantity, tipo') ->get(); I did the count by type of…
I am using Laravel 5.7 and i need to generate top selling products of current month for my reports. So i join two table products and sells. I want three columns in return which are sell_quantity, product_name*, and product_id. So…
I have a table of requests from which I want to select everything, and I have a related table of positionReports where I want to select only the most recent report. The below SQL does what I want as long…
Describing the scenario I have this table called event defined in PostgresSQL that, among some not relevant ones, basically has 5 columns: id (integer): primary key of the table date (timestamp): date when the event occurred fk_type (integer): foreign key…
Need to retrieve a column from a group-by query, and this column is not part of the group-by clause. I have a table that receives telemetries from equipments: COLUMNS: transmission_tag varchar -- this is kind of a transmission package identifier…
I have following example: create table products (name text, id integer, type smallint, category integer); insert into products values ('apple', 23, 1, 1200), ('apple', 23, 1, 999), ('apple', 31, 2, 1200), ('apple', 23, 3, 1200), ('orange', 10, 1, 200), ('orange',…
The dataset is like this: g1 = {d1,d3,d5} g2 = {d1,d3,d2} g3 = {d4,d3,d5} I have the following table called director_genre: director_id | genre d1 g1 d1 g2 d2 g2 d3 g1 d3 g2 d3 g3 d4 g3 d5 g1…
I have many records in the table. I was grouped by continuous date. example : begin_at (From Date) end_at (to date) 2023-05-05 00:00:00 2023-06-18 00:00:00 2023-06-11 00:00:00 2023-06-18 00:00:00 2023-06-12 00:00:00 2023-06-18 00:00:00 2023-06-13 00:00:00 2023-06-18 00:00:00 2023-06-14 00:00:00 2023-06-18…