I have a database like in the attached picture I want to make a query that will display: Home Away Score home Score away Date TeamName1 TeamName3 3 2 2023-03-15 TeamName2 TeamName1 0 1 2023-03-10 TeamName3 TeamName2 2 2 2023-03-09 TeamName1 TeamName4 4 3 2023-03-13 Please help. Thank you in advance. I’m learning sql and… Read More How can I make a query (SQL) with two tables?

I have a non-normalized table that’s arisen from joining three different tables together that are joining against the PrimaryId field. Most fields have valid values for all fields, but some are missing values in identifiers PrimaryId, Name, Internal_System_One_Identifier, Internal_System_Two_Identifier, abc123, ‘Joes Supermarket’, ’22e0b9f6′, NULL abc123, ‘Joes Supermarket’, NULL, ’22e0b9f8′ abc124, ‘Suzannas Coffee’, ’22e0ba6c’, NULL abc124,… Read More How can I normalize a MySQL table that contains NULLs in some fields for some records but not all?

I have a table in oracle that I’m trying to write a query for but having a problem writing it correctly. The data of the table looks like this: Name ID DATE Shane 1 01JAN2023 Angie 2 02JAN2023 Shane 1 02JAN2023 Austin 3 03JAN2023 Shane 1 03JAN2023 Angie 2 03JAN2023 Tony 4 05JAN2023 What I… Read More Oracle: Retrieving specific group of records based by date

I have two tables Loan Repayment Schedule loan: id is primary key id, closedon_date – 1, 2022-05-01 2, 2022-06-01 repayment_schedule: loan_id is Foreign key id, loan_id, principal_amount, due_date – 1, 1, 100 2022-05-01 2, 1, 100 2022-06-01 3, 2, 200 2022-05-01 4, 2, 200 2022-06-01 5, 2, 200 2022-07-01 I want to write a select… Read More How can I write a SQL select query where condition depends upon another table?

I’m trying to perform a query that returns an aggregation of values from the same table with information from others through a foreign key, but I can’t. In the example below, I wanted to return the total sales by state on 2020-01-01 and 2021-01-01, showing the name of the state. Tables script: CREATE TABLE IF… Read More Group table results with information from another

I am trying (and failing) to check if an option exists in the select element, based on the option’s text: <select id="select"> <option value="13">I1</option> <option value="23">I21</option> <option value="954">I33</option> </select> var select = document.getElementById(‘select’); findInvoice(44); function findInvoice(value_option) { let x = select.value = […select.options].findIndex(option => option.text === ‘I’ + value_option); console.log(x); } This does output the… Read More javascript find select option index based on option text

So I have a table with name, quantity and price name quantity price "custom-row" a 12 5 12*5 b 20 3 20*3 c 18 10 18*10 Is it possible to add a "custom" row when using a select query? And I want the values in that row = quantity * price. How can I do… Read More Add custom row when using select query

I’m trying to turn a list of tables on this page into a Pandas DataFrame: https://intermediaries.hsbc.co.uk/products/product-finder/ I want to select the customer type box only and select one of the elements (from first to last) and then click find product to display the table for each one before concatenating all the DataFrames into 1 DataFrame.… Read More Python Pandas Web Scraping

I can’t get this to work CREATE TABLE `oc_tax_class` ( `tax_class_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; — ——————————————————– — — Table structure for table `oc_tax_rate` — CREATE TABLE `oc_tax_rate` ( `tax_rate_id` int(11) NOT NULL, `geo_zone_id` int(11) NOT… Read More mysql insert into select join – copy values from one column to another table, passing through a connecting table