I have 2 tables: google_analytics and marketing_costs. How can I join these 2 columns (google_analytics['source'] with marketing['medium']) even tho they don't
I'm going to migrate data from PostgreSQL database to Yandex's ClickHouse. One of the fields in a source table is of type JSON - called additional_data. So, Pos
I'm trying to run the weighted moving average Silota query with similar data in a Presto database but am encountering an error. The same query in the Redshift d
I have a table. There is data in this table and there is a checkbox next to each data. Multiple selection is possible. After the user makes a selection, the id
I've been trying to filter the data for the last X number of days. All these columns work as standalone results when I remove the time filter from the where cla
I get error "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used
I have following two tables: comments comment_post_ID status comment_type 1 complete course_status 2 complete course_status a1 complete lesson_status a2 passed
Task: Write a query that returns a list of houses from the TB_ELEKTROSTAL_2018 table. It is considered that all subscribers who have the same address belong to
I have these 6 tables and query which returns everything I want, but I want to add a new pivot table, so I can get a list of rows linked to it. Query: SELECT DI
Postgres method array_position(array, element), like other things in SQL, is 1-based. For example: SELECT array_position(array[4,5,6], 5) -- returns 2 But,
I have a table in which there is a field last_update_date in which the date is displayed in short form like 25/02/2015.If I want to extract the date in long dat
The main goal is to create a function that updates 3 columns on another table (the update of the 2 columns from the first table trigger the update on the second
This topic has been covered several times but I can't find a solution that applies to SQL Runner, which is the custom query portion of Google's Looker platform.
I am running the delete query with the < (less then) and > (greater then) condition on the timestamp field but we are not getting the desired results. Fir
I'm having trouble passing a Unicode string to an SQL query via parameter. Initiate the connection and execute the query: conn = pymssql.connect(server='serverN
So I got an admin dashboard which are not linked by ID but by name. So developer.name is the core name, dateName and absentName are meant to j
I am using Hacker Rank to learn SQL sufficiently to pass coding interviews. I have noticed an error in the online compiler when I run it using DB2. In Oracle,
How do I filter records by date? I have the value 1639082700 which is equal to 2021-12-09 23:45:00. I need to find all data for 2021-12-09 which is equal to 163
I'd like to connect to a power BI database and query it using SQL. My first instinct was to use Python's pyodbc package, like so: conn = pyodbc.connect( 'DRIVER
keeps loading what should I do?