I have a table that keeps track of runs. It has the following columns: ID distance run_time run_date 1 10 01:35:00 2023-12-10 2 10 01:48:00 2023-12-16 3 10 01:25:00 2023-12-17 4 10 01:41:00 2023-12-23 I want to calculate the average…
$rooms3 = Room::join("notifications", "notifications.room_id", "rooms.id") ->where('rooms.user_id', Auth::user()->id) ->join("watt_histories", "watt_histories.notification_id", "notifications.id") ->where('notifications.id', 'watt_histories.notification_id') ->latest('watt_histories.created_at') ->first(); If the query runs well, the return given is not null
Imagine a table that looks like | sender_ID | Receiver_ID | message_ID | , say table name is **tb** now I want to write an SQL query that gives me : user_id, Total messages exchanged by that user . So…
I will have to produce a result set which returns the month in each year that produced the highest sales? The tables of interest would be the products table, the order table and the date-time table. The current ERD for…
I have a postgres db that runs on an AWS RDS instance. It contains a somewhat complicated materialized view (created by four left joins). I would like to drop it but the query never completes (no error message, it seems…
I have an Athena table with a string column which looks like: +-------------------+ | employee_size | +-------------------+ | GREATER THAN 2000 | +-------------------+ | 500 - 999 | +-------------------+ | 28.00 | +-------------------+ | unknown | +-------------------+ | 563 |…
Context I have the table (hs_buildings) in my Postgresql DB containing the Point location of my buildings (hs_buildings.coordinates). Then I have a raster containing the land use in stored in a Postgresql raster table (named hs_raster_values). The resolution of the…
I need to fetch data like the below: select u.id from public.user u where u.reporting_id in (select u.id from public.user u where u.reporting_id = ?) is there any best way of doing same in PostgreSQL
I have an postgres table in the below structure I want to write a query which will Delete all the records from the table which are older than 90 days and is in COMPLETE status. if any row has a…
I'm trying to make a custom table widget in filament for showing best selling products. When I do sum(quantity) as total_quantity, it gives me Column not found error. Here's my entire code and the error message : public function table(Table…