根据日期和其他表选择行

I have three tables:

我有三张桌子:

computers, which has columns for id, serial number, make, model, etc
users, which has columns for id, real name
computer_usage, which has columns id, computer_id, user_id, start_date, end_date
computers, whi