I am trying to implement an appointment manager for a dentist office. Thing is I am not sure how to properly implement such function. Right now I have managed to create these two tables that will handle it: CREATE TABLE…
I have a dataset looks like this: Link_number Houband Time Mean_speed Sample_Number Link 1 8 8:00 52 2 Link 1 8 8:30 55 5 Link 2 9 9:00 20 3 Link 2 9 9:30 40 4 I need to do…
I am trying to query a table in Snowflake that is built with a single field labeled "Value" and each row is a separate JSON object. Row 1: { "artist": { "artistID": "artist_1", "artistName": "Roblox" }, "descriptors": { "styles": […
Given a postgres table containing the following items: tag_id, duplicate_tag_id, tag_created_at_timestamp 14175, 14178, ... 14175, 14177, ... 14176, null, ... 14177, 14178, ... 14178, 14179, ... 14179, null, ... 14180, null, ... 14181, null, ... Is it possible to write…
I'm working RWFD emergency room dataset, which includes patient's race and what department they were referred to. I'm trying to show which department each race (7 total) is most commonly referred to, with the stipulation that department_referral is not 'None'.…
I'm working on a recursive SQL query in PostgreSQL to find the minimum cost required to reach various cities from Montreal. The data follows a directed acyclic graph (DAG) structure, where each flight connection is represented in a Flights table…
I'm doing this StrataScratch SQL question. The suggested solution uses two subqueries for each max value of each department, and then it substracts them to get the absolute value. I wanted to solve this question using dense_rank/rank window function by…
I have a table: create table accounts_service.operation_history ( history_id bigint generated always as identity primary key, operation_id varchar(36) not null unique, operation_type varchar(30) not null, operation_time timestamp with time zone default now() not null, from_phone varchar(20), user_id varchar(21), -- and…
I'm working with PostgreSQL and using pg_export_snapshot() to create a snapshot in one transaction, which I then import into another transaction using SET TRANSACTION SNAPSHOT. I noticed that PostgreSQL requires the original (exporting) transaction to stay active while the snapshot…
I wish to achieve something like this from a MYSQL SELECT query I wish to group the results from the select in 500 rows (per batch) and have a column called group (or anything) for the key to the group…