Message from @godric
Discord ID: 541097084552609804
Never visited the site
@NuclearReactionary San Jose is basically same as SF, in which case any salary I quoted for NY you can tack on 10-15% on. But I'm skepical of those payscale estimates for front end devs unless you qualified them as people with a Bachelor's in CS, or who have many years of experience.
Ok @ThisIsChris . Hmm. Well, we'll see what happens. I teach web dev anyway, so this program isn't terribly expensive as a form of professional development.
Another thing to consider: In my current position my salary isn't likely to grow much, if at all. Meanwhile, the salaries as a web dev _start_ maybe a bit below what I make now and grow far above whatever I'll ever make in my current employment.
@NuclearReactionary yes, also with respect to you pointing out you teach at a private school, I see what you mean. Private school teaching, afaik from my dad, doesn't compensate nearly as much.
$142,000 avg salary in San Jose, CA
$143,000 avg annual rent for 1br apartment in San Jose, CA
π
@Tanner - SC The Bay is bananas!
BS! A 12k/month apartment?! Thatβs not an avg apartment!
Last time I was out there, a small 2 bedroom ranch outside the city was ~$800k
@micbwilli what do you think of "the singularity" and brain emulation? I was talking to a friend about it earlier today.
I listened to Kaczynski manifesto on the progress of man and industrialization. I got 2 big take aways from it.
You can't end the progress due to an inability to make a simultaneous revolutionary impact.
Who controls and builds the last machine brain build by a man will ever build might decide if human existence continues.
@micbwilli π’ scary stuff
Does anyone have any experience with visual basic and the correct way to save a project's files? Gotta love putting in extra hours at school just to get a zero on something because it didn't save properly... π‘
<@&387091385075105804> <@&435155896780324864> ?
^
Did you get any feedback on what was wrong with your submission
"does not have all project files to run the program"
Using visual studio?
Yup
I've never used vb, but you'll want to include all of the cls, frm, and bas files as well as the visual studio project file (maybe .sln). If you want to test it, move the whole thing to a different folder and see if it runs. That'll help you understand all the files you need.
I basically need to know how to save both the design and code files and then put them in a .zip file.
To make a zip file, select all the files you want, right click -> send to -> compressed folder
The files should all be saved all ready in your project folder
Do we have any actuaries or CFAs in here?
Pic somewhat related. I want to work with him.
π
okay can someone help me with this?
Determine which books cost less than the average cost of books in the same category.List the title, the category, and the cost of these books.
apparently this is the answer, but I don't really get it
```SQL
SELECT a.title, b.category, a.cost
FROM books a,
(SELECT category, AVG(cost) averagecost
FROM books
GROUP BY category) b
WHERE a.category = b.category
AND a.cost < b.averagecost;
```
I see no numbers
it's not a math question
it's just SQL
oh ya I forgot to tag <@&435155896780324864>
I ended up writing my own solution like this
```SQL
SELECT BOOKS.Title, BOOKS.Category, BOOKS.Cost
FROM BOOKS, (SELECT BOOKS.Category, AVG(BOOKS.Cost) AverageCost
FROM BOOKS
GROUP BY BOOKS.Category) AverageCosts
WHERE BOOKS.Category = AverageCosts.Category
AND BOOKS.Cost < AverageCosts.AverageCost
```
idk if the first one is better
mine feels less convoluted
@Jacob I agree yours is less convoluted that the first one, but I would do
```sql
SELECT Title, Category, Cost FROM
(
BOOKS
INNER JOIN
(
SELECT Category, AVG(Cost) as avg_cost FROM
BOOKS GROUP BY Category
)
)
WHERE Cost < avg_cost
```
haha wow that's a lot less