I have the following code: query = "SELECT * FROM appointments WHERE service IN %s AND location LIKE '%London%'" values = (services,) # services is a tuple of strings. cur.execute(query, values) When I execute this code I get the following…
There is a database with online store customers, which has the following data: id buyer's; order number; date and time of the order; order amount. Data on customers and orders for 3 months. How to withdraw customers who made more…
I have two users: alice and bob. I have one organization: contoso. Alice is member of contoso. What I want is for alice to be able to add bob as member of contoso since alice is member of contoso. I…
I have two tables like this: collection_id added_on edited_on 1 2024-06-19 20:16:41 null 2 2024-06-19 20:17:42 null 3 2024-06-19 20:17:57 null and detail_id collection detail_type detail_value 1 1 title Book title 1 2 1 author John Doe 3 1 publisher…
I have following data in tourament MySQL table. id name team 1 Warren A 2 Carol B 3 Donna 4 William A 5 Andrew C 6 Neil A 7 Max A 8 Phil 9 William 10 Keith 11 Phil I…
I'm working on an application that has an issue in production where one query throws a timeout. The app uses MySQL. SELECT `tags`.*, COUNT( ct.contact_id ) AS contacts_count FROM `tags` LEFT JOIN `contact_tag` AS `ct` ON `tags`.`id` = `ct`.`tag_id` WHERE…
I'm trying to filter products by their attributes that are in the linking table Product => product_has_attribute => Attribute I was only able to do OR, but I need to make a more precise filter. Thanks for any hint! ps:…
I have a table like below. For a given id & a_id there could be different combinations of b_type, e_id, sp_id. br_type can be either B or H. b_type values EA means Excluded Party A, EB means Excluded Party B,…
I get this error: ERROR: 42601: syntax error at or near "ON" LINE 23: ce.image from cars_images ce ON (c.id = ce.car_id)) as images here is my code: SELECT c.id, c.model, c.description, c.environment, c.equipment, c.ps, c.tuv, c.cover, c.brand, c.price, c.engine,…
I'm studying Employees Sample Database which has the following table. create table dept_emp ( emp_no int not null, dept_no char(4) not null, from_date date not null, to_date date not null, primary key (emp_no, dept_no), constraint dept_emp_ibfk_1 foreign key (emp_no) references…