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.

@Ekdromoi ^

😂

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

I think our teacher wants us to get practice with subqueries on this assignment, though

@Jacob well the avg cost part is calculated with a subquery

oh that's right

I don't think we officially learned to do subqueries in the JOIN clause yet

but that looks like a better solution for the future, thanks

Pretty cool article: https://www.sciencehistory.org/distillations/magazine/isaac-newton-and-the-american-alchemist