I have to join user_name from user table where as first_name and last_names from user_profile table. Until here everything is fine, but when I try to fetch respective roles assigned from user_role tables it gives multiple rows for single user…
I have a Users table (id, name, created_at) and a Transaction table(id, user_id, created_at, amount). For each month, I would like to know the number of users who did not have any transaction in the 3 months interval before that…
I am trying to set an alias name for column challenge_name especially when I encounter 'challenge' based on timestamp/date as challenge 1, challenge 2, etc. If it's not 'challenge' I would like to set the column name the same as…
I have table with 3 columns: ID, Cancellation_Policy_Type Cancellation_Policy_Hours. The query I would like to get to will allow me to select: the min Cancellation_Policy_Hours which correspond to the Free Cancellation (if exists) if the above doesn't exist for the…
We store volunteer hours in a database for every user, i'm trying to figure out how to structure a Postgres SQL query to find the percentage of total hours a specific user has spent at a location vs the total…
A table called api_call_data is being used in a seperate database (done by the original code author, not me) which is located in another server in our Laravel project (I can't move the table). Due to that, the original query…
I have table like follows location rank location_A 1 location_B 2 location_C 3 location_D 4 location_E 5 location_F 6 ・ ・ ・ And, closest location = location_E and second scond closest location =location_D so I would like to get following…
I am getting the error: Error Code: 3780. Referencing column 'category' and referenced column 'category_id' in foreign key constraint 'product_ibfk_1' are incompatible. drop table if exists Provider; drop table if exists Category; drop table if exists Product; create table Provider…
I am creating a sports database and am trying to add a trigger to my DDL. The aim of the trigger is to insert values into a table (commitment) whenever another table (player) has a college commitment (col_commit) change from…
I am trying to create a group that has the right to create databases and roles. And then inherit these privileges with the next role. But the error constantly pops up that I don't have rights Edited: (mistake between 'gg'…