Let's show what we know

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

/*
On the right hand side of the window there's a box 
It says "Database Schema" 
You can click the names of the tables (like Posts) to contract or expand them

I'd prefer to assess what you do know, but in reality you'd be googling

1. Finish what queries you can
2. Don't worry if you dont get it exactly or cant remember the exact syntax
3. Talk through your thought process, especially if the question is confusing
4. You're not expected to finish!
5. You 

*/
--- return 1 row from Posts
select top 1 *
from dbo.Posts

--- return the 1 row from VoteTypes with the biggest Id
select top 1 *
from dbo.VoteTypes
order by Id desc

-- return the count of all the Votes that where created in 2019
select count(*) as vote_count
from dbo.Votes as v
where 
v. creationdate >= '2019-01-01' 
and v.creationdate < '2020-01-01'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results