I am using the Python tweepy library to scrap and collect tweet data for a research purpose. Specifically is use tweepy.StreamingClient class to get tweet the from stream. Returned data is json object whose elements depends on the data fields available with retrieved tweet post. So for example, at one time I …
SQL, like, after characters
It’s possible to do a LIKE SQL after some characters? I wanted “LIKE” sql after “:” with ” A” So, REGEX like should be return only the first and third sentence. For the fourth sentence, i added ” ANSWER” should not itself return because the regex is ”…
SQL Left Join after UNION, error in your SQL syntax [closed]
Closed. This question needs debugging details. It is not currently accepting answers. Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question. Closed 4 months ago. Improve this question This…
Oracle: How to get first returned record and previous record
I want to grab the first returned record and previous record based on a user input date. Example, I put in 7/5/22, and I want to grab that date’s food value and somehow include the record previous to that, so output would be: If I put in 3/16/22, then I want my output to be: My totally wrong code: Answe…
PostgresSQL: Get first and last values of an entities chain (self referential table)
I have a table where entities are events. Each event belongs to a group. Each time a new event for this group is inserted, it refers last event of same group on the attibute field “prior” (self referential FK). The other attributes are the id of the event itself, the group which the event belongs …
Window Function w/ a case statement
enter image description hereHelp for a newer SQL analyst: I need to get MAX value from the YearMo column by company, where Prem is zero/null. I created a flag to find YearMo where the sum is 0, indicated by a ‘1’ in the exclude column. How can I edit my current window function to include a case st…
Query to get the latest treatment for each machine
Let me just start by saying that I don’t care on which type of SQL I get an answer on. In reality I am creating my question in Kusto but the Kusto thread in stackoverflow is dead most of the time. This is just to give me an idea of on which way I could do this so I can
Multiple conditions in CASE WHEN statement
I’m working in SQL (Amazon Redshift) with Recruitment data where each applicant has multiple sources, which I’ve split into different columns called source_1, source_2, and source_3, along with a number_of_sources column to record how many sources that applicant has. We want each applicant to only…
PostgreSQL find the sum of two queries from different tables
I have two queries that returns the total number of issuances and redemptions from two different tables. This one returns issuances, around 18k This one returns redemptions, around 7k I need the sum of them, I came up with this but this only returns 2, counting it wrong What should I do? Answer
Update table to make primary key out of two foreign keys
Have a table sample_tag which already exists with 1000’s of entries. It consists of two foreign keys, sample_id and tag_id. However, the database is allowing duplicate sample_id/tag_id records to be created. Without creating a new table, is there a SQL statement to update the sample_tag table such that …