I have a reports table which looks like something as follows: Reports is monthly reports of users putting their efforts. It's many to many relationship table. id user_id project_id total_effort created_at 1 5 232 40 2023-01-23 I want to get…
I have a table with codes for multilingual commands with a structure like this: id code lang text 1 exit_command de Fenster Schliessen 2 exit_command en Close window .... (The column lang also contains other languages such as Italian, Japanese,…
My task is to create a function that concatenates the first name and last name from two fields found on the same table. Table "cust": cus_id f_name l_name email 1 Jack Daniels [email protected] 2 Jose Quervo [email protected] 5 Jim Beam…
I am currently studying SQL and I am still a newbie. I have this task where I need to split some rows with various entries like dates and user IDs. I really need help +-------+------------------------------+---------------------------+ | TYPE | DATES |…
I have a table with b-tree index on column A (non-unique). Now I want to add a check for uniqueness of column A and column B combination when inserting, so I want to add a unique composite index (A, B).…
I have a table with an item, its cost and the date it was added. CREATE TABLE item_prices ( item_id INT, item_name VARCHAR(30), item_price DECIMAL(12, 2), created_dttm DATETIME ); INSERT INTO item_prices(item_id, item_name, item_price, created_dttm) VALUES (1, 'spoon', 10.20 ,…
I'm trying to build a pandas df with an SQL postgres timescale db query and this works below but the problem is the query builds an enourmous file for the one point I am after /5231/REGCHG total_power. The data has…
I have 3 tables: customers (CustomerID) orders (OrderID, CustomerID) orders_products (OrderID, ProductID) I need to select each customer with their total orders and total number of products ordered by them. To count total orders by each customer, the query is:…
Mysql version: 8.0.21 I am lookig of get the latest value of each "TableData" which has the type "fruit". Table Name: TableNames _________________________________________ | id | name | id_group | type | |-----------------------------------------| | 0 | AppleGroup | apple |…
the query is CREATE TABLE order( order_id int primary key, customer_name varchar(30) not null, product_name varchar(20) not null, date_ordered date, quantity int, unit_price float, phone_no varchar(20) ); the error is : ERROR 1064 (42000): You have an error in your…