Correct queryIntermediate5 questions

Correct the query

NULL handling, aggregates, anti-joins and OR precedence in SQL and Eloquent.

01This query is meant to list users that have not been soft deleted, but it returns no rows. What is the fix?
```
SELECT * FROM users WHERE deleted_at = NULL;
```
aWHERE deleted_at == NULLbWHERE deleted_at IS NULLcWHERE deleted_at = ''dWHERE NOT deleted_at
02Which query lists the customers who have placed more than five orders?
aSELECT customer_id FROM orders WHERE COUNT(*) > 5 GROUP BY customer_idbSELECT customer_id FROM orders GROUP BY customer_id WHERE COUNT(*) > 5cSELECT customer_id FROM orders GROUP BY customer_id HAVING COUNT(*) > 5dSELECT customer_id, COUNT(*) > 5 FROM orders
03Which query returns the users who have no orders at all?
aSELECT u.* FROM users u INNER JOIN orders o ON o.user_id = u.id WHERE o.id IS NULLbSELECT u.* FROM users u LEFT JOIN orders o ON o.user_id = u.id WHERE o.id IS NULLcSELECT u.* FROM users u LEFT JOIN orders o ON o.user_id = u.id WHERE o.id = NULLdSELECT u.* FROM users u, orders o WHERE o.user_id != u.id
04This should return active users who are admins or editors, but it also returns inactive editors. Which version is correct?
```
User::where('active', true)
    ->where('role', 'admin')
    ->orWhere('role', 'editor')
    ->get();
```
aUser::where('active', true)->orWhere('role', 'admin')->orWhere('role', 'editor')->get()bUser::where('role', 'admin')->orWhere('role', 'editor')->where('active', true)->get()cUser::where('active', true)->where(fn ($query) => $query->where('role', 'admin')->orWhere('role', 'editor'))->get()dUser::where('active', true)->where('role', 'admin')->where('role', 'editor')->get()
05The phone column is NULL for some users. What is the difference between these two counts?
```
SELECT COUNT(*), COUNT(phone) FROM users;
```
aThere is none; both count all rowsbCOUNT(phone) counts distinct phone numberscCOUNT(*) skips rows that contain any NULLdCOUNT(*) counts all rows; COUNT(phone) counts only rows where phone is not NULL

Answers are scored on the server. Unanswered questions count as incorrect.