I have database that looks like this CREATE TABLE code ( id SERIAL, name VARCHAR(255) NOT NULL ); INSERT INTO code (name) VALUES ('random_value1_random'); INSERT INTO code (name) VALUES ('random_value123_random'); CREATE TABLE value ( id SERIAL, name VARCHAR(255) NOT NULL…
I am trying to write a query that returns list of customer names that do not start or end with letter "A" (either in upper case or lower case). Following is my query, SELECT * FROM Customers WHERE CustomerName IN…
I have 2 tables Customer and Orders. 1st question: That is a master table for Customers that have a few columns like Customer number, customer name, Active flag, etc. Table may contain 2 or more records for the same customer…
I have a mysql table with the following columns- Date, country, YEAR, MONTH, supercategory, class, corp_manufacturer, brand, license,item_description,amount, units, arp. Total number of records = 7.1 million Now i want to add a new column which shows the max value…
I have two tables with one referencing the other. CREATE TABLE blogs ( article LONGTEXT, id VARCHAR(255) PRIMARY KEY ); CREATE TABLE blog_eval ( blog_id VARCHAR(255) REFERENCES blogs(id) ON DELETE CASCADE, user_id VARCHAR(255) REFERENCES users(id), is_like BOOLEAN, --true if like…
I'm trying to join 2 tables and count the number of entries for unique variables in one of the columns. In this case I'm trying to join 2 tables - patients and trials (patients has a FK to trials) and…
We have these tables in PostgreSQL 12: User -> id, name, email items -> id, user_id, description We want to run a query to find users that have 1 item or less. I tried using a join statement and in…
I'm attempting to initialize a table called, "character", in a MySQL server database, and I am getting the SQL syntax error provided below: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server…
here I have tried to rewrite the query with cte cuz of good readability but when I try to rewrite the data is mismatched how to solve the problem for this? Query; select count(1) as rage_tap from ue_summary.summary_funnel_1066 s join…
I have a dumped sql file named my_dump.sql. Within that dump file there are various tables. I'm interested in the table named foo_bars which has a bunch of records. I would like to modify this sql file by doing the…