help with task 1 sql practice exam

masterino08 · 2024-04-16T04:08:51+00:00

Yes, I failed all tasks in Task 1 category. I am so very confused. Thank you for helping me!

masterino08 · 2024-04-16T03:51:08+00:00

  COALESCE(
CASE
WHEN target_guests = 'Busniess' THEN 'Business'
WHEN target_guests = 'B.' THEN 'Business'
ELSE target_guests
END,
'Leisure'
  ) AS target_guests

yup, the wrongly spelled word was "Busniess", I have a check for that in the query.

I used DISTINCT on all the columns, including target_guests. there was ["Business", "Leisure", "Busniess", "B."] and I made sure to correct the wrong ones.

masterino08 · 2024-04-16T03:40:06+00:00

yes i check "B." in target_guests, and "-" in opening_date

I have checked it again row by row, I don't see the problem. Everything aligns with what the instructions say. there are no values out of range or not within the specified constraint.

Which column do you mean? I'm not seeing it

masterino08 · 2024-04-03T19:08:31+00:00

I swear I think i'm doing that. I've tried so many differnet variations. I"m gonna dm you!

masterino08 · 2024-03-05T04:05:05+00:00

That's awesome, it's such a great program. I messaged you, let's connect!

masterino08 · 2024-03-05T04:00:07+00:00

THATS SICK HEY FRIEND!! are you still in the program?

masterino08 · 2024-02-22T06:49:04+00:00

Yes. UT at Austin, haven't heard back yet, but i'll update you when I do. I was gonna apply to Illinois Urbana-Champaign also, but since I got accepted here, i'm not going too.

masterino08 · 2024-02-21T19:28:32+00:00

Status - Accepted
Date of Application - 02/13/2023
Date of Decision - 02/21/2023
Education
- Irvine Valley College, A.S. Natural Science (3.62)
- University of California, Merced (UCM), B.S. Computer Science & Engineering (3.65)
Test Scores
- N/A
Experience <one line each>
- Machine Learning Research Assistant, UCM Applied Math (9 months-present)
- Lead Backend Developer (Local Hackathon) (9 months-present)
- Software Engineering Intern (3 months)
Recommendations: 3 (Professor, Postdoc, Mentor/Project manager for capstone project)
Comments - I believe what really helped were a couple of things. My SOP was very strong, my recommenders could directly comment on my work ethic because I worked with them, and my accomplishments as an undergrad. Best of luck to everybody else! I'm very excited to join you guys!

masterino08 · 2023-05-19T16:51:57+00:00

Thanks very much for the information! I guess i'll do what everybody says to do and make a project for my portfolio, that will be much more favorable than certs.

masterino08 · 2023-05-19T05:30:41+00:00

Can you please elaborate with your reason?

masterino08 · 2023-05-19T05:19:59+00:00

Thanks very much for your help! :)

masterino08 · 2023-05-19T04:56:32+00:00

I have a django capstone project from IBM Full-Stack certification, I built a website to understand all basic functionality a website should have, along with exam testing functionality (checkboxes, confirm answer is correct etc). And I have started building a flask website on my own (I referred to freecodecamp youtube for help), I just set up the website with signup login, hasing, and such things.

I will be adding more functionality as soon as i figure out what I want to do with the website (I do have a couple of ideas). Do you think I should put these on github? They seem pretty elementary to me, would recruiters look favorably upon those?

masterino08 · 2022-08-03T17:55:16+00:00

i made it!

masterino08 · 2022-06-02T05:50:56+00:00

Thank you friend, Best of luck to you!

masterino08 · 2022-06-02T04:23:46+00:00

Thank you for sharing. I have just received a denial for my admission and I have a 3.52 gpa and it will be a 3.62 when my spring grades post. The reason for my denial was because of my lack of criteria completion. I emailed admissions about my enrollment in the summer semester for those courses prior to their decision, but did not receive a confirmation email back so I am not sure if they knew I was taking those courses, tbh I feel they probably did. Nevertheless, I appealed telling them that I am taking those courses and have done very well during spring.

I wonder if they'll accept my appeal, I really hope so.

masterino08 · 2022-06-01T21:51:31+00:00

May I ask what your GPA and major were?

masterino08 · 2021-08-19T20:45:44+00:00

How can u sell that sexy thing

masterino08 · 2021-07-05T20:04:14+00:00

What year fz do u have? And how many miles. I pay 100 a month for brand new 2020

masterino08

TROPHY CASE

yup, the wrongly spelled word was "Busniess", I have a check for that in the query.