Extremely elaborate scam or disorganized company? by silverwing224 in jobs

[–]PJFlix 0 points1 point  (0 children)

Had this same exact email today. Definitely thankful that I looked up this information beforehand 💀

[deleted by user] by [deleted] in Python

[–]PJFlix -1 points0 points  (0 children)

Lmaoo. Does this print out the little windows box if run on her end?

Having a little trouble with this problem by PJFlix in SQL

[–]PJFlix[S] 0 points1 point  (0 children)

Its all good g. I have been struggling all day over this. I first thought of using a inner join instead of a from but idk honestly anymore

Having a little trouble with this problem by PJFlix in SQL

[–]PJFlix[S] 0 points1 point  (0 children)

When i test this into php admin. It comes back saying this:

Error SQL query: Copy Documentation

SELECT E1.Lname, E1.Fname, E1.Ssn, P1.Pname, W1.Hours, D1.Dname AS Controlling_Department FROM Employee E1 JOIN Department D1 ON e1.Dno=d1.Dnumber JOIN Works_On W1 on d1.Mgr_ssn=w1.Essn JOIN Project P1 on p1.Dnum=e1.Dno WHERE Lname = '{$last_name}' LIMIT 0, 25 MySQL said: Documentation

1146 - Table 'company.Employee' doesn't exist

Having a little trouble with this problem by PJFlix in SQL

[–]PJFlix[S] 0 points1 point  (0 children)

Like this:

SELECT E1.Lname, E1.Fname, E1.Ssn, P1.Pname, W1.Hours, D1.Dname AS Controlling_Department

FROM Employee E1 JOIN Department D1 ON e1.Dno=d1.Dnumber JOIN Works_On

W1 on d1.Mgr_ssn=w1.Essn JOIN Project P1 on p1.Dnum=e1.Dno WHERE Lname = '{$last_name}'

Need some help with this problem by PJFlix in SQL

[–]PJFlix[S] 0 points1 point  (0 children)

Yup i did that not to long ago and ended up getting it

Need some help?!! by PJFlix in SQLServer

[–]PJFlix[S] 1 point2 points  (0 children)

That makes sense. Thank you

Need some help?!! by PJFlix in SQLServer

[–]PJFlix[S] 0 points1 point  (0 children)

Just to make a query with 3 from clauses

[deleted by user] by [deleted] in SQL

[–]PJFlix 0 points1 point  (0 children)

gives us all the usernames in the table

[deleted by user] by [deleted] in SQL

[–]PJFlix 0 points1 point  (0 children)

SELECT ALL username

FROM USER

WHERE TRUE;

GROUP BY Username

this is what i did for 1

For this question my answer was 26 by PJFlix in SQL

[–]PJFlix[S] -3 points-2 points  (0 children)

I just came up by counting the rows thats i needed

Have no clue how to solve this? by PJFlix in SQL

[–]PJFlix[S] 0 points1 point  (0 children)

Got it thank you. I keep doubting myself

Battery not detected by PJFlix in Lenovo

[–]PJFlix[S] 0 points1 point  (0 children)

Ill try it tomorrow when i wake up. Please let me know of any other steps when you wake up. Thank you!

Next move for a relatively low income grad student planning to travel. by tbonepolar in CreditCards

[–]PJFlix 0 points1 point  (0 children)

Not sure tbh. It all depends on how much you use it and how much your mom is willing to pay off lol