Here is my solution:
UPDATE patients
SET allergies = 'NKA'
WHERE allergies IS NULL;
Also, don't forget to use single quotations for strings and reserve double quotes for columns or table names.
English
Osvaldo Ruiz | Data Analysis
97 posts
Osvaldo Ruiz | Data Analysis
@ORuizCode
Data Analyst | SQL, Python, Power BI, Tableau, Excel | Sharing daily learnings & projects | Open to work | B.S. in Information Systems, ASU 24'
San Diego/Tijuana Joined Haziran 2025
99 Following10 Followers
Here is my practice problem:
Update the patients table for the allergies column. If the patient's allergies is null then replace it with 'NKA'
English
UPDATE vs SELECT in SQL
Today's practice problem was to update a column where the value is NULL and replace it with a string value. At first, I instinctively started with SELECT to view where NULL values were in my column, but stopped
English
A historic night!
Tom Flores, Jim Plunkett, and Ted Hendricks were inducted into the Hispanic Football Hall of Fame ➡️ bit.ly/4f1AIPa
English
I’m working on a job hunting app and I’m have AI rewriting my resume, but it always comes out janky. Does anyone have any tools/tips they can recommend to get a crisp resume created?
English
I understand the desire of wanting a WR at pick 36, but we have young talent still that need a chance to develop. This is a foundation building year, we need to win in the trenches before anything. A DT, NT, G or T at 36 makes most sense.
English
Using Claude to build an analysis and future predictions for MLB games. Any recommendations?
#sportsanalysis #MLB #baseballsavant #MLBanalysis
English
Osvaldo Ruiz | Data Analysis retweeted
LFG!!! Can’t wait to get to work #Raiders
Adam Schefter@AdamSchefter
ESPN Sources: former Ravens free-agent center Tyler Linderbaum reached agreement today on a record deal with the Raiders, who are awarding him with a three-year, $81 million deal that includes $60 million guaranteed and makes him the highest paid interior offensive lineman in NFL history.
English
Osvaldo Ruiz | Data Analysis retweeted
Osvaldo Ruiz | Data Analysis retweeted
Built an HR Attrition Dashboard in Tableau analyzing 1,470 employees.
Key insight: Sales Reps have 40% attrition. Overtime workers leave at 3x the rate.
Interactive filters, KPIs, and heat maps to identify retention risks.
public.tableau.com/views/IBM_Attr…
#DataAnalytics #Tableau #IBM
English
Osvaldo Ruiz | Data Analysis retweeted
Another one today..
Shubham@aShubhamz
Unfortunately, we will not be moving forward with your application………..
English
A rejection letter is worth so much more than silence.
English
@NotElon_Mu5k @arjunmenon100 Oops, missed that part
English
@ORuizCode @arjunmenon100 It’s an internship buddy, not a senior level role.
English
We’re hiring a seasonal football analytics intern here at the Jets. If you’re interested about football and data, this is a good role to work on tying the two together. Please reach out if you have any questions.
teamworkonline.com/football-jobs/…
English
@arjunmenon100 Does this position offer a relocation package?
English
I should’ve clarified but because of the nature of job this will be fully on site, we do not want this person to be remote
English
@DabereNnamani Dashboards! Utilizing API’s to then begin an ETL process and storing them in BigQuery to use SQL. Also using Python with different projects to clean my data. Also, taking a Linux server class to better configure dbs.
English
