Following is my Sample data1 Expected Output1 Here column “CP” and “NNP” are hierarchical (i.e.) we will start with query like below, for a particular NP and then get the corresponding MC and DS values using the below logic first look at value A from column CP and then see if column NN…
How avoid ambiguousness when joining tables with a where statement?
i have a query such as SELECT * FROM bookings left JOIN answers on bookings.id=answers.booking_id where id=1 since both tables have id and booking_id i am getting : column reference “id”…
Counting events with a specified event.value.string_value in big query
This is a follow up question to this question I have a query: Which returns: I now want to update the query to only count those purchases that have That event is stored like so: I added: Is this the correct way to count only those events that has a specified event_params.value.string_value? I am not sure abou…
Percentage in SQL Server
I want to find the percentage between two columns and I tried this : select (count(id)* 100.0 /(select count(id) FROM db.table where log = ’40’)) as percentage from db.table; And the result is this: …
How to Join two tables on two separate variables with one variable having the same name
This is what I have so far. I’m trying to join these two tables and if I do not use a using() function, then SQL tells me there is an invalid relational operator just simply using an ON. However using a “using” also throws an error that I did not end it properly. Any help would be nice, than…
DAU WAU MAU Error in Redshift: [Amazon](500310) Invalid operation: This type of correlated subquery pattern is not supported due to internal error;
I am trying to compute DAU WAU MAU ratios. DAU: active users on the day WAU: active users of the past 7 days MAU: active users of the past 30 days The DAU:WAU, DAU:MAU, and WAU:MAU ratios compute stickiness of user engagement in terms of %. I have a table called my_table that entails datetime_field user_id Th…
How to split data in SQL
I have the following code: Used Table names: WIPtransaction, WIPtransactiontype, Feeearner I want to display two more columns at the end of the output, namely: Invoiced and Uninvoiced. The “Invoicenumber” field in the “WIPtransaction” database will be tested for this. If the “Inv…
How to assign the IDs to the referring table and how to display this correctly? (SSMS)
I am in the process of creating an audit plan using ERD, going off the below image you can see that there’s a permissions table with four FK columns referring to the other four tables PK column. I am just confused as to how the IDs will relate to the other tables and how will it show up correctly in
How do I convert this SQL into LINQ?
How Do I convert this sql query: select * from Trades where tradestatus = 1 and tradetype = 1 and maturitydate < GETDATE() and referenceId not in (select referenceid from Trades where tradetype = 2)…
running sum or cumulative frequency using subquery
Below is the output of cumulative frequency according to datewise, which I want to change into the subquery. The output is also correct but I want to do it by using a subquery. OUTPUT Answer You would use window functions: Not only is this simpler to write, but it should be significantly faster — and no…