This is my query SELECT c.car_name, MAX(DATEDIFF(r.return_date, r.pickup_date)) + 1 AS No_of_Days, DENSE_RANK() OVER (ORDER BY MAX(DATEDIFF(r.return_date, r.pickup_date)) + 1 DESC) as Dense_Rank FROM cars AS c JOIN rentals AS r ON c.car_id = r.car_id WHERE MONTH(pickup_date) = 5 GROUP…
I have a database table like this: item_id sub_item_id ======= =========== 1 11 1 12 1 13 2 21 2 21 -- repeat 2 22 2 23 2 24 2 25 3 31 3 31 -- repeat Is it possible…
so I want to build a intventory Management database. My schema looks like this: Database Schema An Itemclass (screwdriver, hammer, measuring device,...) can have many items (screwdriver1, screwdriver2,...) Everything is fine and working as expected. But now i want to…
I need to insert a specific range of years and months into a table so I can relate some climate data to those dates. Just like the table bellow: year month 1961 1 1961 2 1961 3 1961 ... 1961…
I have 2 tables: Users table id | groups | --------------- 1 | ["1","2"] | 2 | ["2"] | Groups table id | name | ----------- 1 | Test | 2 | Jest | I need to fetch the records…
When I retrieve some elements from the DB with Model::all() or any other such as Model::with(['otherModel')], I get an object with a different date from what the DB shows. On my db: It shows the proper time. But when I…
SELECT e.frist_name, SUM(e.prince), YEAR(e.hire_date) AS year FROM ( SELECT * FROM employee WHERE termination IS NULL ) e JOIN storage s ON e.id = s.eid GROUP BY e.id, e.hire_date; After SQL query I have a table like this: +--------------+---------------+------+ |…
The value saved in the database is 0.0 as numeric data type, I need to retrieve 0.00 with the select. is there a way in postgres?
I have a Postgres db containing a table with a jsonb column tsent that contains the results of targeted sentiment analysis of text in another column. The data is structured like so: CREATE TABLE tbl(id int PRIMARY KEY, tsent jsonb);…
mysql> SELECT 'STATUS', status FROM (SELECT ujm.user_id AS userId, ujm.job_id AS jobId, ujm.job_run_name AS jobRunName, j.response_payload -> '$.isSuccessful' AS isSuccessful, j.response_payload -> '$.error' AS errors, j.response_payload -> '$.destinationDetails' AS destinationDetails, s.name AS statusType FROM user_job_mappings ujm JOIN jobs j ON…