so i have this tables with their own attributes BOOK TABLE BOOKSHELF TABLE STORE TABLE LOCATION TABLE id_book id_bookshelf id_store id_location name name_bookshelf name_store name_location author id_store id_location id_bookshelf And i wanna show this kind of table TABLE_EXAMPLE id_store name_store…
This the example of the table name is merchant_point_log : id created_date merchant_id point_value recent_point status 1 2022-01-02 1 5000 5000 earn 2 2022-01-02 2 3000 3000 earn 3 2022-01-02 1 3000 3000 redeem i would like to show logging…
i want to ask something, so i have a table A that have start_date and end_date column to store the data when there is a failure happened, it look like this rows start_date end_date 1 "2021-08-01 00:04:00" "2021-08-01 02:54:00" 2…
I need to generate a list of dates between two dates start date and end date here I need from 1/1/2022 to the end of the year on AWS Athena without creating table I need only query view the output…
I've got a brand new SQL database inside my new Azure server and I want to allow access to some users that I have designated with the 'Contributor' role, so they can write some SQL code. However, they cannot authenticate:…
I need to get the total price per month. I have inited_time (ex. 20160530105130) first_payment_price deleted I tried grouping by inited_time SELECT inited_time, DATE_FORMAT(inited_time, '%c') as month, SUM(first_payment_price) as price FROM some_table WHERE inited_time > 0 AND deleted = 0…
I have a table where it stores the types of discounts that a user can have. Some users will get the standard discount, but some will get a bigger and better discount. For users who have the biggest and best…
In Postgres, when a table owner, say "xxx" tries to transfer the table ownership to user "yyy", he is getting error ERROR: must be member of role "yyy" When I searched further, it can be fixed in two ways. As…
I have an age on the format 57 years 5 months 7 days, and I want to deduct the date of birth from it in postgresql on a format like yyyy-mm-dd, how do I do that?
I got 3 tables | ID | Name | |:---- |:------:| | 1 | Brie | | 2 | Ray | | 3 | James | Table2 | ID | Q_id | Q_no | ans | |:---- |:------:| -----:|----:| |…