- PGOpenAPI简介
- 接口分级说明
- 请求测试
- 签名认证
- OpenAPI
- 邮局
- 对象存储
- 点鸭赛事
- 转发代理
- PG登录
- 点鸭数据表
- OpenSDK
[2]获取指定赛事的指定答卷
POST
contest/get_answer
赛事
最后修改时间：2024-02-20 05:13:02
责任人：冷鱼闲风
【[2]个人级别】#
该响应数据适用于layui表格。
请求参数
Query 参数
id
string
赛事ID
示例值:
1705298115
t
string
交卷时间戳
示例值:
1705591908
Header 参数
X-Pgaot-Token
string
用户PGToken
示例值:
eyJ1aWQiOiIxMDAwMSIsIm5pY2tuYW1lIjoiXHU1MWI3XHU5YzdjXHU0ZTBlXHU3MGVkXHU3MzJiIiwiYXZhdGFyIjoiaHR0cHM6XC9cL3ExLnFsb2dvLmNuXC9nP2I9cXEmbms9Mjk5MTg4MzI4MCZzPTY0MCZ1PTEiLCJiY21pZCI6Ijg0MzgxOCIsImRhb2lkIjoiODMzNTQiLCJlbWFpbCI6IjI5OTE4ODMyODBAcXEuY29tIiwiaWF0IjoxNzA4MzExNjQwLCJleHAiOjE3MDk1MjEyNDAsInRva2VuIjoiMDY2MzJjOThmZGFlMDFmZWEzYTU0YTQwMGFkMmNiMDUiLCJqdGkiOiJjdk9Fd20zSGNYUzJzQXdqODlIbnVuK21KeFpOcSt1TU96YXFoTmJDYmJFXC9iSlZDcDd1U1Noc05XQXFpdVJXQUgwWFVPVURoTXExTlA2RVpaREtxY2hzUk1uWlhNTDFzdHV5UHo0ak53cGd0T2RiOVFwUFlBZ3FYNEVkZ2s4XC9MTzZEaERORzNBUm1vYnd6M2U0OTZORDVWeG5hME02OVdPeml0Sk5ReWtjM0tGR29UZVFZZStYcFY3UE5ydldoeFRxdzZuZEFLcUY1TGtyRnU0aytPMjJ6NXIyUG1xN0VFcUc4TTkzdVBlalFXV1JxRzNMZlwvN3cwU0JmZEdKaU9CY3g0c2Y2Z1NpRkdzdExSeFRCa2YzQ2pWdW85ZlJISWVPbVpjNCtjSGRNK0pHMFwvU3IxWThJWHNjUHNIOWJYWjNWMnB4XC9XejhmbWh2eGZCVnRFNkVRMk9qUVR3SEdQajlvZnY3TFhsUWN4RFwvVXZhREJFZWhmT01lMEo5U2VwaElSZ0pNNFp0ZjRGMVlQRTg5NkJmdE9GK0xyXC9hd3RVbE8ifQ==
Body 参数application/x-www-form-urlencoded
page
integer
起始数据
示例值:
1
limit
integer
展示多少条数据
示例值:
10
示例代码
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request POST 'https://api.pgaot.com/contest/get_answer?id=1705298115&t=1705591908' \
--header 'X-Pgaot-Token: eyJ1aWQiOiIxMDAwMSIsIm5pY2tuYW1lIjoiXHU1MWI3XHU5YzdjXHU0ZTBlXHU3MGVkXHU3MzJiIiwiYXZhdGFyIjoiaHR0cHM6XC9cL3ExLnFsb2dvLmNuXC9nP2I9cXEmbms9Mjk5MTg4MzI4MCZzPTY0MCZ1PTEiLCJiY21pZCI6Ijg0MzgxOCIsImRhb2lkIjoiODMzNTQiLCJlbWFpbCI6IjI5OTE4ODMyODBAcXEuY29tIiwiaWF0IjoxNzA4MzExNjQwLCJleHAiOjE3MDk1MjEyNDAsInRva2VuIjoiMDY2MzJjOThmZGFlMDFmZWEzYTU0YTQwMGFkMmNiMDUiLCJqdGkiOiJjdk9Fd20zSGNYUzJzQXdqODlIbnVuK21KeFpOcSt1TU96YXFoTmJDYmJFXC9iSlZDcDd1U1Noc05XQXFpdVJXQUgwWFVPVURoTXExTlA2RVpaREtxY2hzUk1uWlhNTDFzdHV5UHo0ak53cGd0T2RiOVFwUFlBZ3FYNEVkZ2s4XC9MTzZEaERORzNBUm1vYnd6M2U0OTZORDVWeG5hME02OVdPeml0Sk5ReWtjM0tGR29UZVFZZStYcFY3UE5ydldoeFRxdzZuZEFLcUY1TGtyRnU0aytPMjJ6NXIyUG1xN0VFcUc4TTkzdVBlalFXV1JxRzNMZlwvN3cwU0JmZEdKaU9CY3g0c2Y2Z1NpRkdzdExSeFRCa2YzQ2pWdW85ZlJISWVPbVpjNCtjSGRNK0pHMFwvU3IxWThJWHNjUHNIOWJYWjNWMnB4XC9XejhmbWh2eGZCVnRFNkVRMk9qUVR3SEdQajlvZnY3TFhsUWN4RFwvVXZhREJFZWhmT01lMEo5U2VwaElSZ0pNNFp0ZjRGMVlQRTg5NkJmdE9GK0xyXC9hd3RVbE8ifQ==' \
--data-urlencode 'page=1' \
--data-urlencode 'limit=10'返回响应
🟢200成功
application/json
Body
code
integer
必需
msg
string
必需
count
integer
必需
data
array [object {32}]
必需
public
string
必需
name
string
必需
cover
string
必需
range
string
必需
organizers
string
必需
orguid
string
必需
describes
string
必需
participatingcandidates
string
必需
reviewcandidates
string
必需
times
string
必需
total
string
必需
Coorganizers
string
必需
tourl
string
必需
time
string
必需
uid
string
必需
contestid
string
必需
paper
string
必需
scores
string
必需
data
string
必需
certificate
string
必需
nickname
string
必需
email
string
必需
examduration
number
必需
screen
integer
必需
type
string
必需
title
string
必需
issue
string
必需
answer
string
必需
id
string
必需
examanswer
string
必需
actualscore
string | integer
必需
actualscorecause
string
必需
totalRow
object
必需
score
integer
必需
示例
{
"code": 0,
"msg": "赛事答卷信息请求查询成功",
"count": 5,
"data": [
{
"type": "文本题",
"title": "<p>欢迎来到点鸭数据表&SQL基础测试，</p><p>在本场考试中，我们只会在一张数据表里面查询，不会涉及多表查询，</p><p>以下是本场考试的数据表内容，你可以随时回到本题查看表内容。</p><p>下方数据纯属虚构，姓名是随机生成的，如有雷同敬请谅解。</p><p>（点击图片可以放大，鼠标滚轮可放大缩小）</p><p><br></p><p><img src=\"https://static.codemao.cn/bcx/B1cU6wzt6.png?hash=FqPAUfrv2lST916KPtf601Zkbzpq\" alt=\"\" data-href=\"#\" style=\"\"/></p>",
"issue": "",
"scores": "0",
"answer": "",
"times": "1705307372",
"id": "3ee499323b3d064d903db4d856b1454a",
"examanswer": "",
"actualscore": ""
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询姓名叫\"吴珣\"的同学，输出所有字段的内容。</p><p><br></p><h2>A：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 姓名=\"吴珣\"</code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT 姓名,性别 FROM `pgaotdbs` WHERE 姓名=\"吴珣\"</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 姓名<>\"吴珣\"</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 姓名==\"吴珣\"</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "A",
"times": "1705307657",
"id": "b1cd1550a912dbb2f62057d1f1617dac",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询第二组的同学选修日语的数量，输出姓名字段的内容。</p><p><br></p><h2>A：</h2><pre><code class=\"language-sql\">SELECT count(姓名) FROM `pgaotdbs` WHERE 小组=\"第二组\" OR 选修课程=\"日语\"</code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT 姓名 FROM `pgaotdbs` WHERE 小组=\"第二组\" AND 选修课程=\"日语\"</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT count(姓名) FROM `pgaotdbs` WHERE 小组=\"第二组\" AND 选修课程=\"日语\"</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT count(姓名) FROM `pgaotdbs` WHERE 小组=\"第二组\" AND NOT 选修课程=\"日语\"</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "C",
"times": "1705308246",
"id": "a2b9687b6b29ba789c5e98d23123d65d",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询不及格（<60）的选修课程的同学，输出所有字段。</p><p><br></p><h2>A：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE NOT 平均分<60</code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 平均分<60</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 平均分>60</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 平分>60</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "B",
"times": "1705308770",
"id": "c1551785f319ab76c8c682326822c38f",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询没学过\"Perfect\"老师讲授的课程的学生姓名，但第二组除外和\"董为恬\"和\"伊熹能\"除外，输出姓名字段的内容。</p><p><br></p><h2>A：</h2><pre><code class=\"language-sql\">SELECT 姓名 FROM `pgaotdbs` WHERE 授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 NOT IN(\"伊熹能\",\"贡梁淞\")</code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT 姓名 FROM `pgaotdbs` WHERE 授课教师<>\"Perfect\" AND 小组<>'第二组' OR 姓名 NOT IN(\"伊熹能\",\"董为恬\")</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT 姓名 FROM `pgaotdbs` WHERE 授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 IN(\"伊熹能\",\"董为恬\")</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT 姓名 FROM `pgaotdbs` WHERE 授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 NOT IN(\"伊熹能\",\"董为恬\")</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "D",
"times": "1705309066",
"id": "3acd6afaa003a984104bd6e26a518837",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：修改姓名叫\"温冰宏\"的同学，小组改为\"第三组\"。</p><h2>A：</h2><pre><code class=\"language-sql\">UPDATE `pgaotdbs` SET 小组=\"第组\" WHERE 姓名=\"温冰宏\"</code></pre><h2>B：</h2><pre><code class=\"language-sql\">UPDATE `pgaotdbs` SET 小组=\"第三组\" WHERE 1</code></pre><h2>C：</h2><pre><code class=\"language-sql\">UPDATE `pgaotdbs` SET 小组=\"第三组\" WHERE 姓名=\"温冰宏\"</code></pre><h2>D：</h2><pre><code class=\"language-sql\">UPDATE `pgaotdbs` SET 小组=\"第三组\" WHERE NOT 姓名=\"温冰宏\"</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "C",
"times": "1705309725",
"id": "8d0684f2444ce3328e5efe1130e4c319",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询不是\"英语\"的课程分数小于60，按分数降序排列的学生信息</p><h2>A：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 选修课程<>\"英语\" AND 平均分<60 </code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 选修课程<>\"英语\" AND 平均分<60 ORDER BY 平均分 DESC</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 选修课程<>\"英语\" AND 平均分<60 ORDER BY 平均分 ASC</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 选修课程<>\"英语\" OR 平均分<60 ORDER BY 平均分 ASC</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "B",
"times": "1705311231",
"id": "f03cd6033ed2c85cbaa92a53e98d2629",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询祖籍为\"广\"字开头的同学，输出\"授课教师\"字段的内容。</p><p><br></p><h2>A：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 祖籍 LIKE '%广'</code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 祖籍='广'</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 祖籍 LIKE '广'</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 祖籍 LIKE '广%'</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "D",
"times": "1705311909",
"id": "13bd49d47f8bfc251e63a64712e5c860",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【点鸭数据表基础】：查询平均成绩大于等于 60 分的同学的学生授课教师和学生姓名和平均成绩，并以降序的方式输出。</p><p>SELECT <span style=\"font-size: 13px;\"><u>[fields]</u></span> FROM `pgaotdbs` WHERE <span style=\"font-size: 13px;\"><u>[filter]</u></span><span style=\"font-size: 13px;\"> ORDER BY </span><span style=\"font-size: 13px;\"><u>[sort]</u></span></p><ul><li style=\"text-align: left;\"><span style=\"font-size: 13px;\"><u>[fields]【SELECT】字段筛选</u></span></li><li style=\"text-align: left;\"><span style=\"font-size: 13px;\"><u>[filter]【SELECT】条件筛选</u></span></li><li style=\"text-align: left;\"><span style=\"font-size: 13px;\"><u>[sort] 【SELECT】字段排序</u></span></li></ul><h2>A：</h2><pre><code >fields=授课教师,姓名,平均分\nfilter=平均分>=60\nsort=平均分 DESC</code></pre><h2>B：</h2><pre><code >fields=授课教师,姓名,平均分\nfilter=平均分=60\nsort=平均分 DESC</code></pre><h2>C：</h2><pre><code >fields=*\nfilter=平均分>=60\nsort=平均分 DESC</code></pre><h2>D：</h2><pre><code >fields=授课教师,姓名,平均分\nfilter=平均分>=60\nsort=平均分 ASC</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "A",
"times": "1705312178",
"id": "8875439f3afb181231875612ef244053",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【点鸭数据表基础】：查询没学过\"Perfect\"老师讲授的课程的学生姓名，但第二组除外和\"董为恬\"和\"伊熹能\"除外，输出姓名字段的内容。</p><h2>A：</h2><pre><code >fields=姓名\nfilter=授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 NOT IN(\"伊熹能\",\"贡梁淞\")</code></pre><h2>B：</h2><pre><code >fields=姓名\nfilter=授课教师<>\"Perfect\" AND 小组<>'第二组' OR 姓名 NOT IN(\"伊熹能\",\"董为恬\")</code></pre><h2>C：</h2><pre><code >fields=*\nfilter=授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 IN(\"伊熹能\",\"董为恬\")</code></pre><h2>D：</h2><pre><code >fields=姓名\nfilter=授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 NOT IN(\"伊熹能\",\"董为恬\")</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "D",
"times": "1705315455",
"id": "5ee715e271ee356629b70ab498dc9ebd",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【点鸭数据表基础】：删除第一组的同学</p><ul><li>[filter]【UPDATE】条件筛选</li></ul><h2>A：</h2><pre><code >filter=小组=\"第一组\"</code></pre><h2>B：</h2><pre><code >filter=小组=\"第二组\"</code></pre><h2>C：</h2><pre><code >filter=小组<>\"第一组\"</code></pre><h2>D：</h2><pre><code >filter=1</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "A",
"times": "1705316462",
"id": "2f022cbd5e032bf43028b33cc199e873",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【点鸭数据表基础】：新增一位新同学，祖籍\"河北\"，姓名\"凌志豪\"</p><p>INSERT INTO `pgaotdbs`(<span style=\"font-size: 13px;\">[fields]</span>) VALUES (<span style=\"font-size: 13px;\">[filter]</span>)</p><ul><li><span style=\"font-size: 13px;\">[fields]【INSERT】需要设置的字段</span></li><li><span style=\"font-size: 13px;\">[filter]【INSERT】需要设置的值</span></li></ul><h2>A：</h2><pre><code >fields=祖籍,姓名\nfilter=河北,凌志豪</code></pre><h2>B：</h2><pre><code >fields=祖籍,姓名\nfilter=\"河北\",\"凌志豪\"</code></pre><h2>C：</h2><pre><code >fields=*\nfilter=\"河北\",\"凌志豪\"</code></pre><h2>D：</h2><pre><code >fields=祖籍\nfilter=\"河北\"</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "B",
"times": "1705316813",
"id": "92f072ea3fe7717d3abe157d369b370d",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【点鸭数据表基础】：修改名字为\"傅凡慧\"的成绩为 80 分</p><p>UPDATE `pgaotdbs` SET <span style=\"font-size: 13px;\"><u>[fields]</u></span> WHERE <span style=\"font-size: 13px;\"><u>[filter]</u></span><span style=\"font-size: 13px;\"> </span></p><ul><li style=\"text-align: left;\"><span style=\"font-size: 13px;\"><u>[fields]【UPDATE】需要设置的字段和值</u></span></li><li style=\"text-align: left;\"><span style=\"font-size: 13px;\"><u>[filter]【SELECT】条件筛选</u></span></li></ul><h2>A：</h2><pre><code >fields=平均分=80\nfilter=姓名=\"傅凡慧\"</code></pre><h2>B：</h2><pre><code >fields=平均分=80\nfilter=姓名<>\"傅凡慧\"</code></pre><h2>C：</h2><pre><code >fields=姓名=80\nfilter=平均分=\"傅凡慧\"</code></pre><h2>D：</h2><pre><code >fields=平均分=50\nfilter=姓名=\"傅凡慧\"</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "A",
"times": "1705317783",
"id": "440d900c6879c7d8fd4eb75f528d582c",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "操作题",
"title": "<p>【点鸭数据表基础】： 查询任何一门课程成绩在 60 分以上的姓名、课程名称和分数，并按照分数降序处理。</p><p>运行结果参考：</p><p><img src=\"https://static.codemao.cn/bcx/SkDRJjMYp.png?hash=FlIgG_bJvgUGP58ESsWA4X1BWbIF\" alt=\"\" data-href=\"#\" style=\"width: 758.00px;height: 418.67px;\"/></p>",
"issue": "21",
"scores": "10",
"answer": "姓名,选修课程,平均分 || 平均分 DESC || 平均分>60",
"times": "1705320136",
"id": "252fa8ea192a417d018d39fff52363a8",
"examanswer": "",
"actualscore": ""
},
{
"type": "操作题",
"title": "<p>【点鸭数据表基础】： 查询名字中「贺」开头的姓名的学生信息</p><p>运行结果参考：</p><p><img src=\"https://static.codemao.cn/bcx/Bk-YZoMFp.png?hash=FtDkiWFFwLfbSTgdNkfyIw0HGVIp\" alt=\"\" data-href=\"#\" style=\"width: 697.00px;height: 109.20px;\"/></p><p><br></p>",
"issue": "21",
"scores": "5",
"answer": "|| 姓名 LIKE \"贺%\" ",
"times": "1705320610",
"id": "df181d8bf9f988ffead5d5382ef14384",
"examanswer": "",
"actualscore": ""
},
{
"type": "操作题",
"title": "<p>【点鸭数据表基础】：查询没学过\"Davida\"老师讲授的课程的学生姓名，除了\"温冰宏\"和\"傅凡慧\"，和平均分大于等于80的。</p><p>运行结果参考：</p><p><img src=\"https://static.codemao.cn/bcx/HJzDQozY6.png?hash=FkKOiw3HRfDSs2s76FA17KNIBRlu\" alt=\"\" data-href=\"#\" style=\"width: 839.00px;height: 240.48px;\"/></p>",
"issue": "21",
"scores": "10",
"answer": "姓名 || 授课教师<>\"Davida\" AND 平均分<80 AND 姓名 NOT IN(\"温冰宏\",\"傅凡慧\")",
"times": "1705320874",
"id": "41c9179900e7d3796b19d61a6940c955",
"examanswer": "",
"actualscore": ""
},
{
"type": "操作题",
"title": "<p>【点鸭数据表基础】：计算所有同学英语平均分的平均分</p><p>运行结果参考：</p><p><img src=\"https://static.codemao.cn/bcx/r1gmrjMta.png?hash=Fum5X3O2d2a_E7pK9HzzSJIuqZv7\" alt=\"\" data-href=\"#\" style=\"width: 661.00px;height: 76.31px;\"/></p>",
"issue": "21",
"scores": "5",
"answer": "AVG(平均分)",
"times": "1705321350",
"id": "9568b094670bf991ea8799e9e1739013",
"examanswer": "",
"actualscore": ""
},
{
"type": "操作题",
"title": "<p>【点鸭数据表基础】： 查询第二组和第三组的英语最高分的同学，以姓名，小组，平均分方式输出</p><p>运行结果参考：</p><p><img src=\"https://static.codemao.cn/bcx/SJPQ8iMta.png?hash=Fqa6uaQhPSWq9Fuf4RmvIzvmsCVR\" alt=\"\" data-href=\"#\" style=\"width: 735.00px;height: 106.56px;\"/></p>",
"issue": "21",
"scores": "10",
"answer": "姓名,小组,MAX(平均分) || 小组 IN(\"第二组\",\"第三组\") ",
"times": "1705321773",
"id": "2fab70cdd37c0b9754d7382546f35be0",
"examanswer": "",
"actualscore": ""
}
],
"totalRow": {
"score": 0
}
}