A table (phototag) consists of two foreign key columns (photoid, tagid). I want to get the most related photos based on their tags. There are 4 million photos with 5-10 tags. For example, the photoid 10009 has 6 tags. I…
hi im trying to get the total of two columns stored to a name then get a condition but i having error on the 'Rebound' name on line 3 the offreb and defreb has a integer type and some values…
I have this table that has a 'unique together' index: CREATE TABLE IF NOT EXISTS entity_properties ( entity_id INTEGER NOT NULL REFERENCES entities, property_id UUID NOT NULL REFERENCES properties, value VARCHAR, value_label VARCHAR, UNIQUE (entity_id, property_id) ); I want to…
I have a table set up with many columns (up to 15) and they are made to hold the value of what each column is supposed to hold, making all but two be able to intake NULL values. Here is…
I have a table with two columns item_name, value where item_names looks like "abracadabra_prefix.tag_name". And I need to select rows with tag_names from a list that doesn't have a prefix. Should be somthing like: tag_names = ['f1', 'k500', '23_g'] SELECT…
I've two tables magento_customerbalance -mcb column - 1. balance_id 2. customer_id 3. website_id 4. amount 5. base_currency_code customer_entity_varchar -cev column - 1. value 2. attribute_id 3. entity_id 4. value I've tried to find customer_id from mcb which does not have…
I have a SQL table of date entries with three columns: date, item, and status. The table appears like this: date item status 2023-01-01 A on 2023-01-01 B on 2023-01-01 C off 2023-01-02 A on 2023-01-02 B off 2023-01-02 C…
I have this working static query: SELECT companyname, companyid, incorporationcountryid, periodEndDate, filingdate, AVG(dataitemvalue) FILTER (WHERE menmonic = 'AT') as "AT", AVG(dataitemvalue) FILTER (WHERE menmonic = 'COGS') as "COGS" FROM aaa3 GROUP BY companyname, companyid, incorporationcountryid, periodEndDate, filingdate ORDER BY companyname,…
Let's say I have a table with Columns A, B, C, D, E and F. How would I query for entries where (A, B, C, D, E, F) = (1, 2, 3, 4, 5, 6) but only a subset of…
Given a data set of orders, I want to be able to get the distributors ranked in the top 200 based on the total amount of sales generated such that users having the same (total sales) figure are ranked equally:…