Final release note touchups (#15740)

diff --git a/dev/changelog/47.0.0.md b/dev/changelog/47.0.0.md
index 68dd597..64ca2e1 100644
--- a/dev/changelog/47.0.0.md
+++ b/dev/changelog/47.0.0.md
@@ -19,7 +19,7 @@
 
 # Apache DataFusion 47.0.0 Changelog
 
-This release consists of 362 commits from 95 contributors. See credits at the end of this changelog for more information.
+This release consists of 364 commits from 94 contributors. See credits at the end of this changelog for more information.
 
 **Breaking changes:**
 
@@ -94,6 +94,7 @@
 - fix: Rewrite `date_trunc` and `from_unixtime` for the SQLite unparser [#15630](https://github.com/apache/datafusion/pull/15630) (peasee)
 - fix(substrait): fix regressed edge case in renaming inner struct fields [#15634](https://github.com/apache/datafusion/pull/15634) (Blizzara)
 - fix: normalize window ident [#15639](https://github.com/apache/datafusion/pull/15639) (chenkovsky)
+- fix: unparse join without projection [#15693](https://github.com/apache/datafusion/pull/15693) (chenkovsky)
 
 **Documentation updates:**
 
@@ -134,6 +135,7 @@
 - Add coerce int96 option for Parquet to support different TimeUnits, test int96_from_spark.parquet from parquet-testing [#15537](https://github.com/apache/datafusion/pull/15537) (mbutrovich)
 - STRING_AGG missing functionality [#14412](https://github.com/apache/datafusion/pull/14412) (gabotechs)
 - doc : update RepartitionExec display tree [#15710](https://github.com/apache/datafusion/pull/15710) (getChan)
+- Update version to 47.0.0, add CHANGELOG [#15731](https://github.com/apache/datafusion/pull/15731) (xudong963)
 
 **Other:**
 
@@ -398,6 +400,7 @@
 - Fix internal error in sort when hitting memory limit [#15692](https://github.com/apache/datafusion/pull/15692) (DerGut)
 - Update checked in Cargo.lock file to get clean CI [#15725](https://github.com/apache/datafusion/pull/15725) (alamb)
 - chore(deps): bump indexmap from 2.8.0 to 2.9.0 [#15732](https://github.com/apache/datafusion/pull/15732) (dependabot[bot])
+- Minor: include output partition count of `RepartitionExec` to tree explain [#15717](https://github.com/apache/datafusion/pull/15717) (2010YOUY01)
 
 ## Credits
 
@@ -406,12 +409,12 @@
 ```
     48	dependabot[bot]
     34	Andrew Lamb
+    16	xudong.w
     15	Jay Zhan
     15	Qi Zhu
     15	irenjj
-    15	xudong.w
-    12	Chen Chongchen
-    12	Yongting You
+    13	Chen Chongchen
+    13	Yongting You
     10	Tommy shu
      7	Shruti Sharma
      6	Alan Tang