I'm going over a coding assignment, and I'm running into an error I can't solve. I build a database and try to insert tables into it: CREATE TABLE city( city_id INT NOT NULL, city_name VARCHAR(50) NOT NULL, state VARCHAR(20), zip…
I have some columns with PII that I need to share with a coworker. They need to be able to see 50% of the characters and the other 50% should be replaced by Asterisks, but I dont know how to…
I have a dataset with ecommerce events: create table sample_events( event_date date, "session" varchar, "user" varchar, page_type varchar, event_type varchar, product int8); INSERT INTO sample_events (event_date,"session","user",page_type,event_type,product) values ('2022-10-01','session1user1','user1','product_page','page_view',0), ('2022-10-01','session1user2','user2','listing_page','page_view',0), ('2022-10-01','session1user2','user2','search_listing_page','page_view',0), ('2022-10-01','session1user3','user3','product_page','page_view',0), ('2022-10-01','session2user1','user1','product_page','add_to_cart',20969597), ('2022-10-02','session2user1','user1','order_page','order',0), ('2022-10-02','session2user3','user3','product_page','add_to_cart', 34856927), ('2022-10-02','session3user3','user3','product_page','add_to_cart', 19848603), ('2022-10-04','session4user3','user3','order_page','order',0); What I…
I wanted to print only one part of string in column and ignore the remaining stuff including special characters, how can i acheive it | A | B | | -------- | -------------- | | abc | zet=kadala; | |…
I think I have created a stored procedure using the following: CREATE FUNCTION select_all_employee_demographics() RETURNS REFCURSOR LANGUAGE plpgsql AS $$ DECLARE cur REFCURSOR; BEGIN OPEN cur FOR SELECT * FROM EmployeeDemographics; RETURN cur; END; $$; Then I tried to delete…
Supposed I have data as below: id cnt insert_time 1 234 1679131273 2 12 1679131273 3 80 1679131514 4 30 1679131514 5 124 1679131605 6 4.3 1679131605 7 4 1679131935 8 1.5 1679131935 9 5 1679292635 10 56 1679292635 I…
I have a JSON column in bigquery as such SELECT PARSE_JSON('{"a": [1,2,3], "b":[4,5,6]}') AS key_values; Is it possible to write a query such that I can get the following? I can have any number of keys so I cannot specify…
I have 4 Tables : 1- Suppliers ID_A Supplier_name 1 Apple 2 Xiaomi 3 Nokia 4 Oppo 2- Start Balance ID_B Start Balance 1 1000 2 1000 3 1000 4 Null 3- Invoices ID_C Invoice_value 1 200 1 500 2…
SELECT users.id FROM orders, users, "userEmailCollections", "reviewTracks", "loyaltyCampaignRedemptions" WHERE (orders."restaurantTableId" IN (12,7,9,8,10,11,14,99,100,6) AND users.id = orders."orderUserId") OR ("userEmailCollections"."restaurantId" = 6 AND "userEmailCollections"."userId" = users.id) OR ("reviewTracks"."restaurantId" = 6 AND users.email = "reviewTracks"."email") OR ("loyaltyCampaignRedemptions"."restaurantId" = 6 AND "users".id = "loyaltyCampaignRedemptions"."userId");…
I am trying to setup a simple JDBC client to talk with a database in Ballerina. However the "compile" ( VSCode ) error that is shown says: invalid remote method call: expected a client object, but found (ballerinax/java.jdbc:1.7.0:Client|ballerina/sql:1.7.1:Error)(BCE2421) Here is…