I have these three tables: hotel hotel_id hotel_name room room_id hotel_id room_price room_id start_date price Where ‘start_date’ stores the date the price changed to ‘price’. I know how to query the database to get the price for a given room_id…
I have a table where I record events. These events will come into the system once a minute, per user - on the order of 10's of thousands a minute. But I don't need to save all of them. If…
I'm not sure how to word the question for the title. If there is a correct way to word this question better, I would appreciate it. I have a denormalized table, records, with columns: biz_address, customer_name, dept_ID, order_ID, order_amount. biz_address…
I have SQL view data_start with 3 columns CALMONTH, COSTCENTER, Kontonummer Sample data: CALMONTH COSTCENTER Kontonummer ------------------------------- 202301 A AA 202302 A AB 202101 B BA 202012 B BB 202204 C CA 202312 C CB ... How can I keep…
I have three tables 1. Account 2. dept and 3. managers In the managers table I need to add both account key and dept key as foreign key but one will null and other will have value, means if inserted…
I want to run this query: UPDATE users as u INNER JOIN (SELECT MIN(updated_at) as start, h.uuid From users_history as h where h.promoted = true) new on new.uuid = u.uuid SET u.start_time = new.start; And I'll get the following error:…
Example 1: FROM table1 LEFT JOIN table2 ON table1.id = table2.id AND table2.flag = TRUE Example 2: FROM table1 LEFT JOIN table2 ON table1.id = table2.id WHERE table2.flag = TRUE Q1: Will both of these return the same number of…
I want to be able to extract all values from json in snowflake contains "_sum". I have this format for example: {"260196":7877,"260206":2642,"260216":7620,"260226":7560,"_sum":25699} {"260196":9804,"260206":9804,"260216":9487,"260226":9411,"_sum":38506} I want this results: Total Value _sum 25699 _sum 38506 I try to used this: , TO_VARCHAR(GET_PATH(PARSE_JSON(x),…
I am creating a database that holds information for tests, test questions, and the questions on each test. I have 3 tables: problem, test, & question_list. problem holds the information for a question, test holds the information for a test,…
A_id B_id L M N 1 1 1 1 0 1 2 4 3 2 1 3 2 2 1 2 4 2 2 1 2 5 3 2 1 2 6 1 1 0 3 7 4 3 1…