Subobject and "best" value query

Standard table

	Assessment name	Assessment year	Assessment value
Subobject and "best" value query	Assessment 1c	2005	14
Subobject and "best" value query	Assessment 1a	2005	13
Subobject and "best" value query	Assessment 1b	2006	2

Best assessment value

{{#ask: [[Category:Assessment]]
  <q>[[Assessment value::{{#ask: [[Category:Assessment]] |?Assessment value|sort=Assessment value|order=desc|limit=1 
|headers=hide|mainlabel=-|link=none|searchlabel=}}]]
  </q>
 |?Assessment name
 |?Assessment year
 |?Assessment value
}}

	Assessment name	Assessment year	Assessment value
Subobject and "best" value query	Assessment 1c	2005	14

{{#ask: [[-Has subobject::{{FULLPAGENAME}}]]
  <q>[[Assessment value::{{#ask: [[-Has subobject::{{FULLPAGENAME}}]] |?Assessment value|sort=Assessment value|order=desc|limit=1 
|headers=hide|mainlabel=-|link=none|searchlabel=}}]]
  </q>
 |?Assessment name
 |?Assessment year
 |?Assessment value
}}

	Assessment name	Assessment year	Assessment value
Subobject and "best" value query	Assessment 1c	2005	14